CSV Import Problem

[tinggg]

Hi

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?

Thanks for any help

[MarcusJT]

I suspect that you've got the "text delimiter" option in the text import wizard set to the wrong value. Check it!

[tinggg]

I can't see a specific 'text delimiter' filed in the wizard box. CAn you tell me where I can expect to see it and suggest what I should change it to?

Many thanks.

[MarcusJT]

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!

[tinggg]

Your a star!

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.

Thanks

[MarcusJT]