How can I import a .txt file in a database with an external file description 
Author Message
 How can I import a .txt file in a database with an external file description

This is my problem,
I want to convert a TXT (with fixed record length no headers) file to a
database file. Can I create a second file with descriptions of all fields
(need to know the format of such) or  do I modify my TXT file and add
information of the fields to it. I tried using a macro in Excel 5.0 but I
had to many fields to define. The excel Macro could not run because of a
command line which was to long.
Can anyone give me an idea how this can be done and what tools I would need
to do so.
(The TXT file is created on a IBM RS6000 machine and downloaded to an NT
server)
Thanks to anyone who can help me out of this one.
Jean-Luc Reygaert



Sat, 01 Jan 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. NEWBIE, URGENT:Please Help : Importing TabDelim txt file into Access Database

2. How to import a txt file inta a database

3. Full text query on external txt files.

4. importing .txt files using a Stored Procedure

5. Importing txt file across the internet

6. txt file import

7. Problem importing TXT Files

8. DTS Import Tab Delimited Data From Txt File

9. Import from txt file

10. Problem Importing from a TXT file

11. importing txt file...


 
Powered by phpBB® Forum Software