Wrox Programmer Forums
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 17th, 2006, 03:02 PM
Registered User
 
Join Date: Mar 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default doCmd.TransferText

If I am trying to export a table in access, I can use the Eport command in the file menu. There, I can specify such things as the delimiter, whether or not to use quotes around text, etc.

I assume to do this in VBA code, I need to use doCmd.TransferText. But in the argument list, I have no way to specify the delimiter. Is there another function?

Dom
 
Old March 31st, 2006, 12:06 AM
Registered User
 
Join Date: Mar 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to brookhou
Default

Can you post the code your using to export?





Similar Threads
Thread Thread Starter Forum Replies Last Post
TransferText Decimals Issue Pavesa Access 0 April 23rd, 2008 06:48 PM
TransferText Ignores Index in Import Specification nancyb Access VBA 1 September 29th, 2006 05:21 PM
Importing HTML using TransferText AvGuy Access VBA 0 April 19th, 2006 02:19 PM
TransferText method sc-prgmr Access VBA 0 October 12th, 2005 09:46 AM
transfertext and dates choatec Access 2 February 24th, 2004 09:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.