I have an existing access database that I have edited to add data columns. When I import the data from excel to the access database it is adding 6 blank rows (which are separating the data). This is happens twice in the data.
I added 3 new columns of data. All the data appears to have imported correctly it just added 6 blank rows twice. I just dont want to have any problems going forward from this point.
So my question is why would it add 6 blank rows?
Access will import everything down to the last row on the spreadsheet with data in it. If you have blank rows of data, but have more data underneath them, they will be imported into Access as an empty record.
It would be best to clean up your spreadsheet so there are no blank rows, but if you can't do that you can run a simple query to get rid of empty records like this:filledfield should be a field in the table that will always be filled in for vaild records.DELETE * FROM tablename WHERE filledfield Is Null
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks