TransferText Overwrites

Feb 18, 2005

hi all,

i am trying to create a CSV file, from three different tables using this code

Code: DoCmd.TransferText acExportDelim, , "tblHeader", Me.Application.CurrentProject.Path & "QediExport.csv", False

the problem is if I do for the second and third table, it gets overwritten, and only the contents of the last table is in the field.

Is there a way to append to the text file using transferText, or should I use a FSO for the second and third table.

BTW, I don't know how to create a FSO, only ASP, not in VBA

Thanx 4 the helps

View Replies


ADVERTISEMENT

TransferText From LAN

May 18, 2007

I am importing a textfile using TransferText. There are about 50000 records in the textfile (6mb in size). When the Database is on the local harddrive the import takes about 5-10 secs.

I had to make the DB available to other people and put it on a LAN drive. When I now run the TransferText the import takes a lot longer. I gave up waiting after 20mins so don't actually have a time how long it takes. I reduced the text file to 14kb just to prove there were no unexpected errors (there were none). I could see the NetWork activity was at about 10-15% while the TransferText was running.

The text file that is imported usually resides in c: emp but moving it to the lan location made no difference.

The Lan connection is a 100Mbps full duplex and is not the problem. It takes 2 secs to copy the DB to/from the lan.

Has anyone got any ideas why it would take so much longer. When running queries on the DB while its on the LAN the response is somewhat slower, compared to being on the local harddrive (instead of 1 sec it takes 2 secs maybe) and that's acceptable and expected.

View 2 Replies View Related

TransferText

Oct 4, 2004

Im new to Access and am trying to export a file to a .txt file using TransferText. I need to export with fixed width so have created an export specifiaction. Probelm is my data contains 2 dates which appear in the database as yyyy-mm-dd but when exported the dashes get dropped. Is there some way of keeping the dashes in the exported txt file.
Cheers

View 4 Replies View Related

Transfertext With Export Delimited

Nov 30, 2007

I have a small table with 3 columns. First and third columns are type text.

When I do transfertext with:

Transfer Type : Export delimited

table : table1

File name D: est.txt

Here is test.txt data:

"jake",10.00,"rock"
"phil",22.20,"man"

Is it possible to get rid of double quotes around the text fileds (columns 1 and 3)?

Thanks,

View 2 Replies View Related

TransferText Import Ignoring The First Line

Sep 26, 2005

I am currently importing data using the the "TransferText" method in Visual Basic; e.g., expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

Per the above description, I can either include the first line as a field name, or as data. Is there any way to simply ignore this data row and start the import from row 2 onwards?

Thanks as always

k

View 2 Replies View Related

Docmd.transfertext Scrambles Data

Mar 6, 2008

I have a delimited file that has 51 fields. I am importing the text into a table but when I do this through VBA docmd.transfertext the data gets scrambled. If I manually import then all works well. Also, if I step through the code then the data seems to come in correctly.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved