asked on

Data Import Errors for Blank Cells

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.

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!

SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shanan212

ASKER

This would be in Access right? I will do that!

Richard Daneke

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

Richard Daneke

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.

Shanan212

ASKER

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

Shanan212

ASKER

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

ASKER CERTIFIED SOLUTION

Shanan212

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mbizup

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.

Shanan212

ASKER

Thanks!