Table Import Error

[kjohnson]

I just hit a large bump in the road...
I tried to import an Excel file (which I have done before with ease),
but this time Im getting an Error. I believe that I formatted the Excel file properly to match the Access Table, but it brings up an error: Subscript out of range.

(And I hope my screenshot link goes through this time...)

http://www.facebook.com/photo.php?pid=1908584&l=6f515&id=685866113

 

[smith9891]

Have you tried importing to a new table and seeing how access set the table field types. I would GUESS its a large number into too small a field type eg a number >32767 into an Integer field.

 

[kjohnson]

ok, so i just copied the excel data to a new blank excel sheet and it works now.
My only guess is that access thought that there was something that I wasnt seeing, like off to the right.
Thanks though. If it ever happens again, I like you idea.