Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 October 12th, 2005, 09:46 AM
Registered User
 
Join Date: Oct 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default TransferText method

Hi Folks,

When test.txt file (delimited separated by commas) is imported using this command

   DoCmd.TransferText acImportDelim, , "TestTable", "d:\Test.txt", False

I get a file conversion error for 1 field type - this field type is declared as a text (it mainly has numbers, but occassionally will have a letter in them). Ex.

   015948888282 - transfers ok
   B10399499293 - is flagged as "File Conversion Error" and placed into a new table.

I can do this process manually, without any problems, but can't seem to get VBA to pull the mixed content (letters and numbers) into the table.

Any suggestions?

JG





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
doCmd.TransferText d_olivastro VB Databases Basics 1 March 31st, 2006 12:06 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.