[AccessD] Import Specs

Charlotte -

I believe my boss has a table containing data that is similar to the
layout of an import spec.

She wants to export this table to text, then import the file as an
import spec.

I think I'm gonna have her try Tom's suggestion with creating the spec
in Excel, then cut and paste into an Access spec.

 

Thanks for the reply.

Mark

 

 

-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
Sent: Thursday, February 20, 2003 11:49 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Import Specs

 

There are two tables that hold the spec,  MSysIMEXColumns and
MSysIMEXSpecs, but they're read only from the database window.  What is
it you want to do with them?

 

Charlotte Foust

	-----Original Message-----
	From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com] 
	Sent: Thursday, February 20, 2003 6:38 AM
	To: AccessD at databaseadvisors.com
	Subject: [AccessD] Import Specs

	Where does Access store import specs?

	I'm guessing there is a hidden system table that holds the
layout for these specs.

	If so, how do I get to them?

	 

	Thanks,

	Mark Boyd

	Sr. Systems Analyst

	McBee Associates, Inc.

	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030220/f8c23e54/attachment-0002.html>