Excel to Access

[cedx]

Hi,

I am working on a project with VB 5 that has and existing "database" in the form of an Excel spreadsheet. Can anyone tell me how to transfer data stored in an Excel spreadsheet into an Access database?

Thanks in advance.

[SmithVoice]

VB5/6 source code showing how to convert Jet to Excel Excel to Jet at:
http://www.smithvoice.com/vbda.htm

No automation of either, it's all SQL. Also see the other demo souce code at that page because converting from Jet to any ISAM or vice versa (or Excel to Lotus to HTML, etc) is all done the same way)

Hope it helps.

-Smith

[bashfirst]

If you don't need to do this programmatically, you can simply open the Excel spreadsheet from Access using the Link Tables function and selecting Excel as the file type. You can then treat the spreadsheet exactly like another Access table.

Bash

[SmithVoice]

Good point