PEB 1,418
Expert 1GB
Hi all,
Yesterday i've tried this command:
DoCmd.TransferText acExportDelim, "Comma_SEP", "myquery", "D:\Temp\Temp.txt"
And it gave me an Error that can't find "D:\Temp\Temp.txt"
This file exists ant i've supposed that should be replaced by new one!
But the transfer was'nt executed!
I've tried using Macro, but the same pb appears!
This is not urgent, coz i've found a solution! Just like a bug in Access!
14 9866
Hey Vladi
If you're D:\ drive is a peripheral drive like CD drive. It may not be able to write to it directly.
Mary
Hi all,
Yesterday i've tried this command:
DoCmd.TransferText acExportDelim, "Comma_SEP", "myquery", "D:\Temp\Temp.txt"
And it gave me an Error that can't find "D:\Temp\Temp.txt"
This file exists ant i've supposed that should be replaced by new one!
But the transfer was'nt executed!
I've tried using Macro, but the same pb appears!
This is not urgent, coz i've found a solution! Just like a bug in Access!
PEB 1,418
Expert 1GB
Hi Mary,
Sure that my HDD is divided to C and D partitions :)
NeoPa 32,556
Expert Mod 16PB
Is the file locked elsewhere.
Perhaps you had it open in another application at the time?
Otherwise I don't know.
Hi Mary,
Sure that my HDD is divided to C and D partitions :)
Try changing the filename and see will it create a new file?
PEB 1,418
Expert 1GB
Is the file locked elsewhere.
Perhaps you had it open in another application at the time?
Otherwise I don't know.
Unfortunately no! It isn't locked... And sometimes it isn't created yet! :(
PEB 1,418
Expert 1GB
Try changing the filename and see will it create a new file?
This gives the same pb!
I know that this kind of functions are null... I've right to develop my own way to export csv!
:)
Don't worry more about it... This is no more as problem for me... I've solved it! But wanted to note it like a bug in Access!
Thanks you both!
Vlady
Hi,
Could you tell us how you solved it please?
I have a similar problem. Access db converted from 97 to 2003.
Now macro falls over with 3027 error on TransferText command.
However, can manually export with no problem!
I think it is a bug too....
OK, thanks, I've looked and can't see it there so I guess it is not a recognized bug except by me and Vlady....
NeoPa 32,556
Expert Mod 16PB
OK, thanks, I've looked and can't see it there so I guess it is not a recognized bug except by me and Vlady....
Sometimes, things can be confusing and don't work the way you expect them to. This doesn't necessarily mean they're a bug. That site can give more information about gotchas as well as just the bugs.
Thanks, I've bookmarked that page for future reference.
Further investigation elsewhere has led me to the solution for my problem (though maybe not Valdy's problem). I was using a .FIL file extension (legacy reasons) whereas from 2000 onwards it expects "valid" file extensions. Changed it to .TXT and it worked a treat!
NeoPa 32,556
Expert Mod 16PB
Yeah, that's a bit naff I know.
I normally use the Name statement afterwards to rename it to what I need (With On Error etc).
SOLVED: I had the same issue. In my case the Export Spec was invalid. I'd created it when exporting a table but then used it on a query (slightly different fields). As soon as I recreate the export spec it work as expected.
instead of a file, create the specification in the import wizard and save it as a name which you will then call from the specificationame in your docmd.transfertext call
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Teresa |
last post by:
I'm trying to import a tab delimited text file.
The text file does not have column heading. I can give it column
heading if needed. How do I change the defult comma delimited to tab?
If I...
|
by: holdemfoldem |
last post by:
Hi. I'm new to this board and have a few questions about using the
method referred to in the topic of this message.
I have manually transferred over 1/2 million records from a text file
into my...
|
by: Chris |
last post by:
Hi,
I am using the command below for exporting data to text file. One of
the query columns has SINGLE number type with decimal ponts as auto.
DoCmd.TransferText acExportDelim,...
|
by: Ryan |
last post by:
Hello. I was hoping that someone may be able to assist with an issue
that I am experiencing. I have created an Access DB which imports an
Excel File with a particular layout and field naming. ...
|
by: veaux |
last post by:
I'm sure this has been answered, and I've looked but can't quite find
what I'm looking for.
I have
Path = "I:/voucher.txt"
DoCmd.TransferText acExportFixed, "voucher_fixed",...
|
by: ProteusGak |
last post by:
Hi there, can anyone tell me how to allow the user to enter in a path on there harddrive for a transfertext item? It works just fine if I set it programmatically, but I really need them to do this,...
|
by: jessek |
last post by:
I’m trying to use DoCmd.TransferText, (I use it successfully with a .txt export every day) to export a table into a CSV file.
Right now every time I try – it says:
Run-time error 3011
The MS...
|
by: amitk |
last post by:
Hello,
I'm using Access 2002-2003. My application exports an Access table into a text file and then appends the text file with several othet files to generate a final file XXXX.ftm .
...
|
by: Cuaracao |
last post by:
This is my code:
Code1:
'DoCmd.OpenTable "tblImport"
'DoCmd.TransferDatabase acExport, "dBASE IV", strOutputDir,acTable,"sel_TblImport", strDbfName & ".dbf", False
'
DoCmd.Close acTable,...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |