Create your own import wizard?

[Kelii]

Hi all,

I'm using Access'03 on a WinXP machine.

I have a small application that tracks invoices, inventories, and sales
data. With regards to the sales data, I want my users to be able to
import data from an Excel spreadsheet. The Data Import Wizard from
Microsoft is great, but I want to be able to add some custom text to
the screens and set defaults for certain "steps" (e.g., disable the
user's ability to choose which table to import data into).

I'm wondering 1) is this at all possible, and 2) does anyone have any
suggestions on a place to start (e.g., website, book, sample code).

Thanks in advance.

Kelii

 

[John Vinson]

Hi all,

I'm using Access'03 on a WinXP machine.

I have a small application that tracks invoices, inventories, and sales
data. With regards to the sales data, I want my users to be able to
import data from an Excel spreadsheet. The Data Import Wizard from
Microsoft is great, but I want to be able to add some custom text to
the screens and set defaults for certain "steps" (e.g., disable the
user's ability to choose which table to import data into).

I'm wondering 1) is this at all possible, and 2) does anyone have any
suggestions on a place to start (e.g., website, book, sample code).

Thanks in advance.

Kelii

Depends on how flexible you want it to be. If you have a standard set
of standardized (HAH! Excel? Who am I kidding??) spreadsheets, you can
just link them using TransferSpreadsheet in VBA code, and create
queries to add the custom text, etc.

If you want users to be able to link to any page of any spreadsheet
and import whatever is there into any table, then... use the wizard.
You'll spend a year writing the code!

John W. Vinson[MVP]

 

[Kelii]

Hah! Well, that's what I needed to know. Thanks.