Import Specifications

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've researched/read the posts in here about the Specs, and would like to
confirm the following:
Once you import a csv file manually and create/save your Import, even if
you delete that table, those specs will remain in your database in the
MSysIMEXSpec hidden table?

Thanks!
 
Hi, Belinda.
Once you import a csv file manually and create/save your Import, even if
you delete that table, those specs will remain in your database in the
MSysIMEXSpec hidden table?
Click to expand...

Yes, but you must save the import specification before the import of the
*.CSV file by selecting the appropriate import settings, then selecting the
"Advanced" button in the Import Text Wizard dialog window, then selecting the
"Save As" button to name the new import specification. Even if the imported
table is later deleted, this import specification will still be available in
this database in the future for subsequent imports, unless the specification
is intentionally deleted, either by using the Import Text Wizard or
programmatically. These specifications are stored in the MSysIMEXSpecs and
MSysIMEXColumns system tables.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


:> Once you import a csv file manually and create/save your
Import, even if
you delete that table, those specs will remain in your database in the
MSysIMEXSpec hidden table?
Click to expand...
 
Thank you Gunny!

When you say "unless the specification is intentionally deleted, either by
using the Import Text Wizard or..." Are you saying that if I perform another
text file import and save the import specifications I will override the
existing spec? Or could i just save different import specs?
 
Hi, Belinda.

You're welcome.
Are you saying that if I perform another
text file import and save the import specifications I will override the
existing spec?
Click to expand...

One _can_ overwrite the saved import specification, but it must be
intentional. To do so, import the file using the Import Text Wizard, then
select the "Advanced" button. Select the "Specs..." button and select the
import specification you want to change. Make the necessary changes, then
select the "Save As..." button and don't change the name of the import
specification when it appears in the "Save As" dialog window. You will be
prompted on whether or not you want to overwrite the existing specification.

Another way to intentionally overwrite the original import specification is
to import the file using the Import Text Wizard, then make the selections
desired, then select the "Advanced" button. Select the "Save As..." button
and type the name of the specification you want to overwrite. You will be
prompted on whether or not you want to overwrite the existing specification.

The other ways to lose the saved import specification are to use the Import
Text Wizard's "Delete" key when the import specification has been selected
(and you'll be prompted "Do you really want to delete this?"), or to
programmatically delete the import specification -- which requires knowing
how to write the code or where to find the code that someone else has
written, then copying/pasting/running this code.

Under no circumstances is the removal of the saved import specification
accidental. If you have users that you worry about deleting your carefully
planned import specifications, then if they wind up missing from the database
you know it was on purpose.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
You're very welcome. And thank you for marking my replies as answers to
your question. It's much appreciated.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
 
Back
Top