Import Wizard

[ManhattanRebel]

I have customized an import wizard to change certain columns to text.
Now I'm trying to use the "Saved Imports" feature of Access to append my
database.

a) How do you append using "Saved Imports" feature?

b)How do you use the "Saved Imports" feature to import a different
spreadsheet than the one that it was originally setup to import?

c) Why does it prompt me: "Do you want to Overwrite Existing Data"

Thank you.
mr

 

[pietlinden]

I have customized an import wizard to change certain columns to text.
Now I'm trying to use the "Saved Imports" feature of Access to append my
database.  

     a) How do you append using "Saved Imports" feature?

     b)How do you use the "Saved Imports" feature to import a different
spreadsheet than the one that it was originally setup to import?

     c) Why does it prompt me: "Do you want to Overwrite Existing Data"

Thank you.
mr

You reuse the import specification in the TransferText method. one of
the arguments is the [saved] specification name you already created.
The fact that you are importing different spreadsheets with the same
specification is not important. What *IS* important is that the
spreadsheets have the same structure - the columns are in the same
order and have the same column names (if they're named).

 

[ManhattanRebel]

Thank you for the help. I understand and have everything in order that you
mentioned, but can you explain where to find and how to use Transfer Text
method.
mr

I have customized an import wizard to change certain columns to text.
Now I'm trying to use the "Saved Imports" feature of Access to append my
database.

a) How do you append using "Saved Imports" feature?

b)How do you use the "Saved Imports" feature to import a different
spreadsheet than the one that it was originally setup to import?

c) Why does it prompt me: "Do you want to Overwrite Existing Data"

Thank you.
mr

You reuse the import specification in the TransferText method. one of
the arguments is the [saved] specification name you already created.
The fact that you are importing different spreadsheets with the same
specification is not important. What *IS* important is that the
spreadsheets have the same structure - the columns are in the same
order and have the same column names (if they're named).

 

[pietlinden]

Thank you for the help.  I understand and have everything in order thatyou
mentioned, but can you explain where to find and how to use Transfer Text
method.  
mr

You reuse the import specification in the TransferText method.  one of
the arguments is the [saved] specification name you already created.
The fact that you are importing different spreadsheets with the same
specification is not important.  What *IS* important is that the
spreadsheets have the same structure - the columns are in the same
order and have the same column names (if they're named).

DoCmd.TransferText