Import Excel (1 Viewer)

esskaykay

Registered User.
Local time
Today, 23:30
Joined
Mar 8, 2003
Messages
267
First off, I'm not a programmer so please bear with me. Maybe I'm asking for too much here but what I’m looking for is some routine to assist in importing data from an Excel spreadsheet. I can do this all manually but have no idea where to begin to automate this. Here's what I do manually (from inside Access2K):

Click on FILE > GET EXTERNAL DATA > IMPORT > c:\paser\wislr.xls > Next
Check "Show range names" > WISLR > Next
Cheek “First row contains column headings” > Next
Check "In a new table" > Next
Check "No primary key" > Next
Import to table = tblWISLR > Finished

Any help would be greatly appreciated.

Thanks,
SKK
 

orna

Registered User.
Local time
Tomorrow, 00:30
Joined
Oct 13, 2002
Messages
78
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblWISLR", "c:\paser\wislr.xls ", True,"A2:G300"
 

esskaykay

Registered User.
Local time
Today, 23:30
Joined
Mar 8, 2003
Messages
267
Excellent - this is exacty what I was looking for.

Thank you very much...
SKK
 

Users who are viewing this thread

Top Bottom