importing excel to access

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top