Excel Import Into Access

[Stan]

I have some data that when exported from an application into Excel has some
blank cells. I've noticed that when I try to paste this data from Excel into
an Access table it deletes any rows that have blank cells in them even though
other cells in that row do have data. Any thoughts on a work around forcing
Access to accept blank cells?

 

[ldiaz]

You can create a blank column on you data base, and on the excel file add a
column with some comments on the rows like "Blankrows", the access data base
will see this row as valid and will be copied into the tables,..

Thanks'
LD

 

[Stan]

I appreciate the reply. I do have an issue with many columns having blank
cells. Any thoughts?

 

[pietlinden]

I appreciate the reply.  I do have an issue with many columns having blank
cells.  Any thoughts?

As long as those fields do not have the Required property set to True,
then you should be fine. You can import into them. Be aware that
Access will throw fits if you define something as numeric and then try
to import text. The import will still fail.