Excel to Access

[ginga]

Okie dokie i have a huge excel spreadsheet and i need to get all the data into an access database but its far too much to be done manually.
can someone write me a script to do it for me? 😃

[Anon]

There is no need. Access has got an option "Import data". You can directly import from Excel and it creates a table with that sheet. At least in Access 2000, but i believe that will wotk in any Access.

Hope this helps

fLIPIS

P.D: Still you don't say to me if you want help with your Access thingy.