Import Spec

  • Thread starter Thread starter David
  • Start date Start date
D

David

Is it possible to create an import spec based upon an
existing table in the database? versus creating the import
spec manually?

Thanks
 
Hi David,

If you're importing a fixed width file the answer is no, because there's
no set relationship between the field type in the database and the
number of characters in the text file.

If it's a "delimited" text file, it's possible in principle but you may
not need an import spec at all: Access attempts to convert the values in
the text file to the field types of the table you're importing to. You'd
iterate through the Fields in the table's TableDef to work out their
properties, and either build an import spec in the undocumented system
tables or (and simpler) create a SCHEMA.INI file containing the spec.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import csv conversion & import spec error 1
Import Spec does not exist 3
How to transfer import/export specs into Access 2007 adp project 5
Edit Import Spec (A2007) 1
27inc high lumen screen recommendation for Australian Client 0
2007 Access Import Spec Saved 3
Import Spec differences in Other Countries 2
Import Specs Changed "Magically" in Midst of Loading Sequence 3

Back
Top