Recent content by gerrywiles

thank you all for the responses - everything is now clear and I have overcome the issue. Just to advise that I had tried to create an export by right clicking the table or query etc and exporting as a Text file. The error I was making was that I was checking the Output with Formatting box and...

I am running vba from a command button to export a query to a csv file. Everything works well but each field in enclosed with quotation " marks. I have read that I need to set or change an export spec (schema.ini) but cannot see how to do this. I can see that by using a wizard I can do this on...

I have a table which is populated from a text file. Within my table I have three fields for the street address, Add1,Add2, Add3. The text file using " as delimiters so I have no issues in populating the Access table from this however the text file only has one field for the street address and...