Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export spec file

Status
Not open for further replies.
PerryG

PerryG

Programmer
Joined
Aug 15, 2000
Messages
75
Location
US
I'm trying to use the specification file with the DoCmd.TransferText. I'm supposed to be exporting a pipe-delimited, no-text-qualifier but all I get is the default comma delimited "" text qualifier. If I walk thru the wizard I get what I want but not with the docmd route.

Help!

Thanks to one and all.

PerryG
 
Sort by date Sort by votes
Click on the 'Save formatted' check box on the export screen.

Cheers

John
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

KeyserSoze
  • Locked
  • Question Question
Import Error Files - Export$_ImportErrors
Replies
1
Views
402
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question Question
Searching for a way to get Access to retrieve and use data from a hard drive file not within Access
Replies
13
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
lameid
  • Locked
  • Question Question
Print To File With Adobe PDF Printer
Replies
0
Views
246
lameid
lameid
Knicks
  • Locked
  • Question Question
LDB File Chinese Characters (Access 2013)
Replies
2
Views
600
Knicks
Knicks
weberm
  • Locked
  • Question Question
Problems with the text file generated by exporting Access 2013 to a delimited text file
Replies
16
Views
945
weberm
weberm

Part and Inventory Search

Sponsor

Back
Top