blank rows getting exported from excel to access

newinvb
03-20-2003, 03:09 PM
I am doing a manual export of data from Excel to Access. Now what happens is, it is exporting blank rows into my table. How do I prevent blank records from getting exported?
Please help, I will need to automate this routine, because I will be exporting lots of separate files into respective tables. But I want to make sure I won't exporting blank records.
Please help, thanks in advance.

Samadhi
03-20-2003, 03:30 PM
Just run a query that deletes the blanks.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum