Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access External data > Docmd.TransferT...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 10830 of 11313
Post > Topic >>

Docmd.TransferText fails to create new table

by =?Utf-8?B?UmljaCBL?= <RichK@[EMAIL PROTECTED] > Jul 24, 2008 at 10:10 AM

A colleague recently converted an Access 97 mdb to Access 2000.

A process that deletes tables and recreates them while im****ting data
fails 
to work.  I believe I've resolved the issue down to this statement:

DoCmd.TransferText acIm****tFixed, "Im****t_HED", "TI_HED", 
Concat_Dir_File(Me![Directory_Location], Me![Collar_ID]) & ".HED", False

Concat_Dir_File is a local sub that creates the file location and name.
That 
works just fine.

Any ideas on why this would work in '97 and not 2000?

What is the meaning of the specification?  Would it be in a file, or is it

set internally in Access?
 




 5 Posts in Topic:
Docmd.TransferText fails to create new table
=?Utf-8?B?UmljaCBL?= <  2008-07-24 10:10:02 
RE: Docmd.TransferText fails to create new table
=?Utf-8?B?S2xhdHV1?= <  2008-07-24 13:10:03 
RE: Docmd.TransferText fails to create new table
=?Utf-8?B?UmljaCBL?= <  2008-07-24 13:48:00 
RE: Docmd.TransferText fails to create new table
=?Utf-8?B?S2xhdHV1?= <  2008-07-24 13:58:01 
RE: Docmd.TransferText fails to create new table
=?Utf-8?B?UmljaCBL?= <  2008-07-24 15:27:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 19:55:51 CST 2008.