Search results

Hi, The error just appears when I change the "txt" extension to "dat" with DoCmd.TransferText In the end I have found this solution that works for me: Public Sub ChangeFileExtension() Dim SourceFile, DestinationFile SourceFile = "c:\testfiles\file1.txt" DestinationFile...

Hi Uncle Gizmo, I have tried and when I use *.txt with DoCmd.TransferText works Ok. The only problem is when I try to export with the .dat file extension. I need to export *.dat with format as later on the data is used by another program to import and is a third party which I cannot change...

Hi, I need to export a .dat file with delimited format (using ";") I have tried the following: DoCmd.TransferText acExportDelim, "ED File", "Employee Data Output", "c:\testfiles\file1.dat", False, "" But when I execute the code the folloing error is shown: Run-time error '3027' Cannot...