Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / August 2004

Tip: Looking for answers? Try searching our database.

Import Specifications - can they be copied

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PaulS - 29 Jul 2004 15:48 GMT
Can import specifications be copied/pasted into a new
database, or exported somehow?
Ken Snell - 29 Jul 2004 16:12 GMT
Yes. When doing the Import process, click on Options >> button and you'll
see "Import/Export Specs" in the bottom lower left. Click the box.

Signature

       Ken Snell
<MS ACCESS MVP>

> Can import specifications be copied/pasted into a new
> database, or exported somehow?
- 29 Jul 2004 19:19 GMT
Sorry - don't see it.  Using Access 2000.  Which screen
should I find this Options button on?

>-----Original Message-----
>Yes. When doing the Import process, click on Options >> button and you'll
[quoted text clipped - 4 lines]
>
>.
Ken Snell - 30 Jul 2004 00:25 GMT
Use File | Get External Data... | Import.

Select the database from which you want to import the specifications. Click
Open.

On the window that shows, click Options >> button. You'll see the info at
bottom left corner of that window.

Signature

       Ken Snell
<MS ACCESS MVP>

> Sorry - don't see it.  Using Access 2000.  Which screen
> should I find this Options button on?
[quoted text clipped - 11 lines]
> >
> >.
ComRev - 05 Aug 2004 22:23 GMT
Pardon me for jumping in on this thread, but this is a topic that is very near and dear to me.  I come from Access from Paradox.  In Paradox, one could create an "Import Specification" table for repetative .txt imports.  I know how to create and save an Import Specs. table in Access 2002 but there are times that I need the exact same Specs in another database.  I have tried your suggestion but do not see the option button to shich you refer.  When I Flie|GetExternalData|Import I get the same screen that I see whenever I import or link to data in another database.  I click on "Advanced" but there is no opportunity to import the specifications form another database.

> Use File | Get External Data... | Import.
>
[quoted text clipped - 19 lines]
> > >
> > >.
Ken Snell - 06 Aug 2004 03:10 GMT
I said nothing about an Advanced button. I'll post the directions for the
third time.

Click File.
Hover over Get External Data...
Click Import...
Navigate to the database from which the specification is to be imported.
Click Open.
In the window, at lower right of of screen, click Options >> button.
Click Import/Export Specs checkbox.
Click OK.

Signature

       Ken Snell
<MS ACCESS MVP>

> Pardon me for jumping in on this thread, but this is a topic that is very near and dear to me.  I come from Access from Paradox.  In Paradox, one
could create an "Import Specification" table for repetative .txt imports.  I
know how to create and save an Import Specs. table in Access 2002 but there
are times that I need the exact same Specs in another database.  I have
tried your suggestion but do not see the option button to shich you refer.
When I Flie|GetExternalData|Import I get the same screen that I see whenever
I import or link to data in another database.  I click on "Advanced" but
there is no opportunity to import the specifications form another database.

> > Use File | Get External Data... | Import.
> >
[quoted text clipped - 19 lines]
> > > >
> > > >.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.