importing excel to access

G

Guest

I am getting ready to start an update to an existing db in which the client
wants to be able to import an excel (or csv) spreadsheet into Access by using
a developed method rather then the File ... get external data ... etc. The
Access version is 2003. I have been reading some posts and they are
indicating that A2k3 does not import spreadsheets or csv's any longer. But
some say it does. Is this true or not that A2k3 imports spreadsheets?
Please let me know before I begin spinning my wheels needlessly.
Thanks in advance.
*** John
 
D

Douglas J. Steele

Access 2003 (and all other versions) imports spreadsheets or csv files with
no difficulty. Look at the TransferSpreadsheet method to do it
programmatically.

The change that happened with respect to Access 2003 and Excel is that
Access 2003 (and 2002) can no long update linked tables which are Excel
spreadsheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subscript out of range when importing into access 2010 from excel 0
importing from Excel To Access 2
Excel And Notepad 3
Is THere a Way to Control How Access IMports Excel Spreadsheets ? 4
Importing Excel Spreadsheet 2
Importing/linking any excel spreadsheet causes Access to crash 1
Importing XML Data in Access 2003 1
Better Way to Import from Excel 2

Top