We help IT Professionals succeed at work.

Data Import Errors for Blank Cells

Shanan212
Shanan212 asked
on
Hi,

I am trying to import an Excel file into a Access db. It is giving me data import errors on blank cells of this file.

screen
I have tried few things,

1. Copy and pasted (values) on to a different workbook, saved it and tried importing it.

2. Imported the headings first, then the data, no use

Any help is much appreciated (to avoid these data import errors)

Thanks!
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
Try creating a 'staging' table with columns having the expected datatypes and import your data into that table.

Author

Commented:
This would be in Access right? I will do that!
CERTIFIED EXPERT

Commented:
If you are still having problems, please post your versions.  Importing is more flexible in current version (AC2010) and may offer another option.
CERTIFIED EXPERT

Commented:
If you save the Excel file as a Tab or CSV file, you will gain more control over the import field definitions by using the Import Wizard.   This will let you declare numeric fields, text fields, and, on dates, the date format.

Author

Commented:
Well, I have tried saving the file as CSV but I couldn't find 'CSV' as an option to import. I am seeing Excel, Text, XML, etc (from other format drop down but nothing for CSV)

I am using Office 2003

Author

Commented:
Please see the attached image.

My major issues are:

- blank spaces (giving type conversion error)
- Other types (as in picture giving same error as above)
Temp.PNG
I've requested that this question be deleted for the following reason:

Found answer by inserting a text column before the first row of raw data
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
Shanan212,

Instead of deleting the question, please use the "Accept as solution" button under your own comment.

This is good information for others in the same predicament.

Author

Commented:
Thanks!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.