• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 885
  • Last Modified:

Having difficulty exporting table to csv file using schema.ini file

I need to export microsoft access 2003 table into a csv file. I am using the TransferText Command and I need to set certain details for the output file. For exampleNumberDigits=4
TextDelimiter=none

I have set these protocols up in my schema.ini file. I have put the schema.ini file into the same folder as the csv file. The when I go to run the TransferText command I get I get error Run-time error '3625': The text file specification does not exist. You cannot import, export, or link using the specification. I have attached my vb code of the TransferText Command and also the schema.ini file
DoCmd.TransferText acExportDelim, "Z:\Swingframe Order Management System\Channels\schema", "ExportChannelsTable2", "Z:\Swingframe Order Management System\Channels\channels.csv"
 
 
 
Here is my schema
 
[Channels.csv]
ColNameHeader = True
CharacterSet = ANSI
Format = CSVDeLimited
NumberDigits=4
TextDelimiter=none
Col1=SalesOrderNumber Integer
Col2=Bin Text Width 50
Col3=Cut1 Double
Col4=Cut1NumberofCuts Integer
Col5=MaterialID Text Width 4

Open in new window

0
swingframe
Asked:
swingframe
1 Solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now