Importing Excel into Access causing major problem 1

[SBendBuckeye]

I have a couple thousand row Excel 97 spreadsheet which I am trying to import into Access 97. One of the columns is mostly numeric with some strings (eg 1000, 2000, G400, etc).

The problem is that during the import process, the field type is disabled so all of the above types are getting thrown out. If I import it from a text file there is no problem in doing that. The spreadsheet has column headers also.

Any ideas or suggestions would be greatly appreciated!

Have a great day!

 

[ploeryan]

You could try it in code/macro using the transferspreadsheet command.

DoCmd.TransferSpreadsheet acImport, _ 8, "TblImported2","C:\Whereever\Excel.xls", True, "A1:G12"