Hi all, every time I try to import an Excel speard sheet into an Access table (existing or new), a few thousand empty record always show up in the resulting table followed by all of the correct data (around 1000 records). This is quite annoying, is there a way to fix this? Thank you in advance!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import from Excel gets extra empty records
- Thread starter Iliemoo
- Start date
LittleSmudge
Programmer
Yes - it is all the problem of Excel trying to be a baby database
It thinks it knows where the data is store and defines it's own 'DataBase' area on the sheet.
When you IMPORT you get the full length of what it thinks of as the database.
To fix it you need to explicitly tell Excel where the real data ends
G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.
It thinks it knows where the data is store and defines it's own 'DataBase' area on the sheet.
When you IMPORT you get the full length of what it thinks of as the database.
To fix it you need to explicitly tell Excel where the real data ends
G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
