I am trying to import data from Excel to Access

[MS]

I am trying to import data from Excel to Access to make a
report, is this possiable?

 

[Douglas J. Steele]

Depends on the structure of the Excel data, but in general, yes, it's
possible. You can use the TransferSpreadsheet method to import the data or
link to the spreadsheet, or you can use Automation (do a search at
http://www.mvps.org/access/ for a sample or two)

 

[MS]

Thank you I'm going to go to that site.

-----Original Message-----
Depends on the structure of the Excel data, but in general, yes, it's
possible. You can use the TransferSpreadsheet method to import the data or
link to the spreadsheet, or you can use Automation (do a search at
http://www.mvps.org/access/ for a sample or two)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)






.