I'm trying to import about 18 excel spreadsheets into one database in Access. I've been using "get external data" to import the spreadsheets as tables, and the first 8 of them worked fine, but now I cannot import any more excel files. The only error message I'm getting is "An error occurred trying to import file 'C:....xls' The file was not imported." And this error pops up after I have gone through all of the importing steps. Did I exhaust Access's resources? It's not a format issue, and I've restarted, etc. I'm at a loss.
Trouble importing external data - Access limit?
- Thread starter Astello
- Start date
neileg
AWF VIP
- Local time
- Today, 20:51
- Joined
- Dec 4, 2002
- Messages
- 5,970
Not a resource issue for Access.
Is the xls file currently open? This will stop it being imported.
Otherwise, there may well be inconsitencies in the data. Access tries to guess the datatypes when you import (based on the first few records). If it guesses wrong, this can cause problems. Are you importing to an existing table or to a new table?
Is the xls file currently open? This will stop it being imported.
Otherwise, there may well be inconsitencies in the data. Access tries to guess the datatypes when you import (based on the first few records). If it guesses wrong, this can cause problems. Are you importing to an existing table or to a new table?
I'm importing to a brand new table. The formats are consistent throughout all of my data, and throughout each column in each separate spreadsheet. It gets through each step (field titles, where to save it, etc.) but when it comes time to actually import the file, it gives me an error.
Similar threads
