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

On 3 Dec 2006 17:16:47 -0800, "Kelii" <(E-Mail Removed)> wrote:

>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]

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