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

S D accessd667 at yahoo.com
Fri Jul 9 01:50:26 CDT 2004


Mark, Charlotte,
 
thnx, but I cannot find this 'option' and 'import/export specs' thingy.
Where did MS put this? Is it in A2K?
 
Sander

"Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com> wrote:
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)" 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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

		
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!


More information about the AccessD mailing list