Need help creating CSV file with Access 2k
Posted on 2014-03-18
I am using Access 2K on Windows XP Professional platform.
I am trying to create a CSV file so I can export information from my database to eBay.
The CSV file must pull the information about the parts I want to sell from my database. In addition, the CSV file must contain addition fields, which will be constant for each record in the csv file.
For example, each record should have a field named ACTION, which must be set to ADD or VERIFYADD.
To do this, I created a form with a combo box named ACTION, and the combo box allows me to select either word.
Next, I build a select query that pulls info from my database in addition to the ACTION combo box using the format [Forms]![frmEbayCreateTemplate]![Action] AS [Action].
The query appears to work. By this I mean it looks exactly as you would expect, except that when I attempt to export it to a csv file I get an error message.
Unable to import into a csv file, I tried to copy and paste the data from the query into an excel spread sheet, and the columns with data, such as the ACTION column, did not paste into the spreadsheet. In other words, all the data pulled from the database pasted fine, but all the data pulled from the form was blank, even though it appeared to look normal in the query.
Any ideas why I can't create a csv file or copy the data?