[AccessD] Import Specs

System tables MSysIMEXSpecs

And

MSysIMEXColumns


Six or seven years ago I was processing a lot of download data from an
AS400. The best I could get was a fixed-width text file. Fortunately, the
download had an optional definition file it could create. Being totally
lazy, I learned to parse the defintion file and import the results into the
Access system tables.

Totally depends on how much you're going to be doing.

Have fun. 


Bruce H. Johnson
Sylmar, CA
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, June 22, 2006 12:34 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Import Specs

Hello All,

In A97 is there a way to view/edit/even know they exist with import 
specifications without pretending to import something?  For example...I have

a db that imports a text file using ImpSpec1...I now need to modify this 
import spec.  The only way I know to do this is to goto 
TABLE/NEW/IMPORT/Select File type TEXT/Select any file(even though I don't 
want to import)/then click ADVANCED.

This seems a little out of the way...is there a menu option somewhere to 
view or edit these specs?

Thanks,

Mark A. Matte


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com