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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing more than 16383 records from Excel 1
- Thread starter Thom
- Start date
Just a few hints that always help me,
let access create the ID's
check the field types in excel, if in dout make them General
make the headers the same names and in the same order as the database, this one seems dumb but it has saved me more then once
HTH "Hacker by Heart"
saenzinc@email.com
let access create the ID's
check the field types in excel, if in dout make them General
make the headers the same names and in the same order as the database, this one seems dumb but it has saved me more then once
HTH "Hacker by Heart"
saenzinc@email.com
-
1
- #3
tlbroadbent
MIS
This is a recognized Access 97 bug. See the article, "ACC97: Data Truncated to 16,384 Rows When Imported into Microsoft Access" at Terry
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question