JMoss
jmoss111 at bellsouth.net
Fri Jul 9 04:15:04 CDT 2004
Sander, >From the database where you are importing the import specs, click on File|Get External Data|Import| the file select dialog will pop up, select you file, which will open Import Objects window. Click Options >> button at bottom right, and the Import/Export Specs checkboix in the Import Group, and anything else that you care to import, and OK. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D Sent: Friday, July 09, 2004 1:50 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Migrate "Import specs" (Was: Set delimiterforDoCmd.TransferText acImportDelim) 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! -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com