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...