Importing from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all!

I have a 16,219 KB file that I am trying to import into Access from Excel -
just basic information (names, numbers, dates). Out of 23,368 rows in excel,
ony 16,383 rows of data import each time I try. Anyone know why?

Thanks so much!
 
Nikila said:
Hi all!

I have a 16,219 KB file that I am trying to import into Access from Excel -
just basic information (names, numbers, dates). Out of 23,368 rows in excel,
ony 16,383 rows of data import each time I try. Anyone know why?

Thanks so much!
Click to expand...
Have you had a look to see where the data end in the database?
You might find that there is a blank row in the spreadsheet, or
something similar - strange characters, missing data - anything that
looks out-of-place.

I've imported a spreadsheet that had over 30,000 rows (not many columns,
but LOTS of rows) without any problems.

An alternative would be to save the data in CSV format (in Excel) and
then import that data into the database.
I've had to do that with many data sources where the data wasn't coming
through in the format that I wanted (numbers instead of text, dates
instead of numbers etc).

Hope this helps.
 
Nikila said:
I have a 16,219 KB file that I am trying to import into Access from Excel -
just basic information (names, numbers, dates). Out of 23,368 rows in excel,
ony 16,383 rows of data import each time I try. Anyone know why?
Click to expand...

Could be a 'mixed types' situation where minority types can't be cast
as the majority type and are being 'seen' as null. For details, see:

http://www.dicks-blog.com/excel/2004/06/external_data_m.html

Jamie.

--
 
I think it's because Access is trying to assign a "Long Integer" data type to
a field that should be a "Double". (Has to do with whether there are decimals
associated with number) Check your data columns as you are importing and
change the data type. You should be able to import all the records after you
do this.

Steve
 
Back
Top