Converting Table design into Import Specs...

T

Trexx

Hello everyone,

I have a table linked to a large text file. The text file is one huge file
where every field is fixed width with no tabs or other separators in between
them. I want to convert the linked table to a standard table & then simply
import the text file into the table so that it will be part of the mdb file
itself. Problem is that there are way too many fields on the text file and
every time I try to import it, the import wizard prompts me for each field
length, type, starting position, etc. There has got to be a better way...

How do I save/convert an existing table desing into an import specification?

Thanks in advance,

Juan
 
J

John Nurick

Hi Juan,

If you're currently accessing the text file via a linked table then
presumably you already have an import specification or schema.ini file
with the field specifications (otherwise the linked table would not have
the correct fields).

So just import the file to a new table using the existing import
specification or schema.ini.

As for your exact question
How do I save/convert an existing table desing into an import specification?
Click to expand...
I don't know any easy way. Instead, use schema.ini:

Create a Schema.ini file based on an existing table in your database:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155512

How to Use Schema.ini for Accessing Text Data
http://support.microsoft.com/default.aspx?scid=kb;EN-US;149090
 
Top