Excel Import Into Access

I have some data that when exported from an application into Excel has some
blank cells.  I have 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?

You can create a blank column on you data base, and on the excel file add

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
--
Lorenzo D??az
Cad Technician

I appreciate the reply.

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

ankdd abases someExcel inton thoughd forcingAs long as those fields do not

ank
dd a
base
s some
Excel into
n though
d forcing

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.