[AccessD] Migrate "Import specs" (Was: Set delimiterforDoCmd. TransferText acImportDelim)

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Thu Jul 8 12:00:56 CDT 2004


Basically, when the question was asked, I just had a flashback that it
required importing a couple of system tables.  I had to actually look to get
the correct table names.  Perhaps my recollection pertained to an earlier
version of Access...before that option existed?  

Thanks for the update though...

Mark


-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
Sent: Thursday, July 08, 2004 12:30 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Migrate "Import specs" (Was: Set
delimiterforDoCmd.TransferText acImportDelim)


Why import the tables?  You can do an import from the database, click on
options, and then select import/export specs.

Charlotte Foust

-----Original Message-----
From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com] 
Sent: Thursday, July 08, 2004 7:10 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Migrate "Import specs" (Was: Set delimiter
forDoCmd.TransferText acImportDelim)


While in your target database, try importing the system tables
MSysImexSpecs and MSysImexColumns from your development database.

Mark


-----Original Message-----
From: S D [mailto:accessd667 at yahoo.com] 
Sent: Thursday, July 08, 2004 9:38 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Migrate "Import specs" (Was: Set delimiter
forDoCmd.TransferText acImportDelim)


Thnx Mark! That did the trick.
 
Any idea if it's possible to distribute these "import specifications"?
So if I create these in my development database is it possible to
migrate them to TEST, Acceptance and finally Production?!
 
TIA
 
Sander
 


"Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com> wrote:
Sander,

When doing repetitive automated imports, I've always used a saved Import
Specification. You can set your delimiter there.


Mark


-----Original Message-----
From: S D [mailto:accessd667 at yahoo.com] 
Sent: Thursday, July 08, 2004 9:08 AM
To: accessd
Subject: [AccessD] Set delimiter for DoCmd.TransferText acImportDelim


Hi group,

is it possible to set the type of delimiter for the TransferText
command?
eg:
, or ; or ~

TIA

Sander


---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list