Import excel into access 2000

[jl39775]

I am trying to import a excel spreadsheet into an access database. The import works, but any cell that has both alphabetic and numeric character does not import. Those fields are left blank and a error log table is created letting me know which row the error occur. Does anyone know how to import an excel spreadsheet properly?

The code I used is below.

DoCmd.TransferSpreadsheet acImport, 3, _
"Employees", "C:\Newemps.xls", True, "A1:G12"

Thanks,

james

 

[Rich_Lovina]

Click File, get External data from Access and follow prompts from there....easy as...

 

[Pat Hartman]

If you append to an existing table, you can avoide this problem by defining the column as text. If you can change the spreadsheet, try changing the type of the column to text instead of general.