Importing an Excel Spreadsheet

[oscarooko]

Hello Peeps,

I'm trying to import an excel spreadsheet into an access table. The excell spreadsheet was created using the access table( by using the 'analyze using excel' feature)

The problem is that I cannot import the updated excell spreadsheet. I get the error message.." An error occured while trying to import the file..the file was not imported"

Does someone have any clues as to how to fix this

 

[Jerry Stoner]

Check your datatypes. Excel may have converted a number to text. You may need to do the import many times leaving out a field at a time till it succeeds. Then you'll know which field is causing the problem. Fix should be simple from there.