Why am I getting blank records in my Access Table...??
Posted on 2006-11-29
I am importing data from an Excel spreadsheet into an Access table daily. Before I import the records each day, I first run a delete query in Access to rid the table of yesterday's records. When I import the new Excel data into the table it is creating several hundered rows of blank records, but it doesn't seem to do it everytime. This makes me think it has something to do with the Excel data I am creating every morning to update the table.
In Excel, I working with a spreadsheet that identifies if a task has been "done" or is "pending".
I only want to take the "pending" records into the Access table. In general, every day the number of "done" tasks goes up, and the number fo "pending" tasks goes down. (Anything to do with the blank records?) I filter the spreadsheet on a column for those identified as "pending" and then I copy those filtered records and paste special into another spreadsheet tab. Then I go to Access and import the "paste special" tab that has the "pending' records on it. But when I check the import I find that even though there were only 12000 records that should have been imported, I am getting 12484.
All this is happening in Office 2000. Any thoughts? - Tom