Excel table (1 Viewer)

Johan

Registered User.
Local time
Today, 07:11
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
 

DES

Technoweenie
Local time
Today, 02:11
Joined
Apr 17, 2001
Messages
245
try

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

HTH

DES
 

Users who are viewing this thread

Top Bottom