Importing/Exporting Fixed Length Text files 
Author Message
 Importing/Exporting Fixed Length Text files
I'm new to ADPs but am wondering which is the most efficient way of
importing and exporting fixed length text files into SQL. I have an ADP
which needs to do both daily.

In Access 97 I created both an import and export specification and then
called the DoCmd.TransferText......etc.

I'd sure appreciate it if someone could provide me with some advice.



Sat, 15 Nov 2003 10:20:41 GMT
 Importing/Exporting Fixed Length Text files

The Access web has several good text import / export routines such as

http://www.mvps.org/access/modules/mdl0057.htm

http://www.mvps.org/access/modules/mdl0058.htm


Quote:
> I'm new to ADPs but am wondering which is the most efficient way of
> importing and exporting fixed length text files into SQL. I have an ADP
> which needs to do both daily.

> In Access 97 I created both an import and export specification and then
> called the DoCmd.TransferText......etc.

> I'd sure appreciate it if someone could provide me with some advice.



Sat, 15 Nov 2003 11:23:13 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Export DB2 Data To Fixed Length Text File

2. Import Fixed Length Text Files

3. Importing fixed length text files

4. how to import fixed length record from text files

5. Importing a fixed fieldwidth, fixed row length file

6. Convert fixed-length text file to delimited text

7. Creating Fixed-Record Length Text File - PL/SQL Command File

8. Importing Fixed length text, need advice

9. Fix Length Text Import always gets 1st char?

10. Short fixed length text import

11. Importing fixed-length text into paradox

12. Fixed-Length Text Import (to .DB)


 
Powered by phpBB® Forum Software