issue exporting access table into txt file with correct format
I have an access table that I need to export to a txt file so I can use it to import into our database. I am exporting it with spaces and a text qualifier with quotes. In the preview screen it looks perfect. The text has quotes around it and the numbers do not but as soon as I export and open it everything has quotes around it including numbers which wont work when I try to import. I need just the text to have quotes. Any idea why it looks fine in the preview but then exports with everything in quotes? I added a couple attachments so you can see what I am talking about. text_document.PNG preview.PNG
How are the number fields defined in the table, and what formatting etc do they have?
Open in new window