View Full Version : Excel table


Johan
04-26-2001, 02:33 AM
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
04-26-2001, 03:27 AM
try

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

HTH

DES