We've got an access (2002) datadase that links to a facility on our website. The database is 8mb.
I update the tables from CSV files extracted from our work database.These tables are quite large, 9000 records with 26-33 fields. I had a lot of problems getting them in to the access tables as they would not import (I guess because of their size), I went through all the steps to getting external data and nothing would happen, the access table wouldn't update in any way. This meant that I had to save each CSV file to excel and cut and past 5000 records at a time. The problem not is that although the update added only another 100 records the database has jumped to 34mb! This is the first time I have done this.
Does anyone know why this has happened and what I can do about it, there aren't any empty record cells or fields and the information is not a significant size?
I don't know anything about VB.
Update: I've just realised that the records that are not importing have inverted comma's " used somewhere in the record - is there anyway to allow these to be recognised and therefore imported?
Click "advanced" on the dialog where you choose between delimited or fixed-width. The option you need is the "Text Qualifier" field, but I can't tell you what you need there unless you post some sample data!
I set the 'test delimiter' box to " (it was previously set to text) and it allowed me to import the records into a linked table and I cut and pasted them in to the correct table and all of them pasted, before the ones with inverted commas went into a paste error file.
Sure there must be an easier way of doing this but at least it worked.