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
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.
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
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,
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
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