Access 2007 export to text file
Posted on 2012-04-11
I have a project where I need to pull in data from an sql table, then have the user be able to change some of the data. Then I need to have the user be able to export the data in a format that is required by another application. That format is very specific. It needs to be pipe delimited without the quote marks. I am new to access, but I thought this would be fairly simple. I created my database and the table using the sql data. That went fine. I created a query to build a single field with the fields in the correct format with the pipe delimiter. My problem has been the export. I tried exporting the query. I left Export data with formatting and layout unchecked. There are 2 options, delimited and fixed width. Delimited is almost good, except it has " marks at the beginning and the end. So I tried fixed width. The problem there is that for some reason it only shows the 1st 5 characters of each record. I don't know why the truncation. If this could be figured out, I think this might work. Any help would be appreciated. I am not a VB programmer.