Excel table

Johan

Registered User.
Local time
Today, 07:54
Joined
Apr 13, 2001
Messages
12
I made an Excel table, and I would like all the data of that table to be fild in A table of my Access dBase.

Is this possible
 
try

DoCmd.TransferSpreadsheet acImport, 8, "Access Table Name", "Location of Excel File", True, "A1:h151"

HTH

DES
 

Users who are viewing this thread

Back
Top Bottom