Accessing Data Import wizard via a macro?

[Madraykin]

Hiya,



I've built a mini database to log requests from a number of people. A lot of the requests coming in will be piecemeal, but occasionally there will be batch requests with multiple records and I don't want the guys to feel they have to go through and fill out the form for each one of those new records.

I have a front end user menu with 'log a new request' etc as options, and I'd like to add a button for 'log multiple requests' that will automatically open the import data wizard so that the user can select their spreadsheet (they'll have been issued with templates) and append to the correct table.

If anyone knows the code for opening the wizard, or can think of a better way to do the above then I'd be really grateful.

I'm ok at building databases, but am a VBA novice and only manage to work my way around doing what I want to do by investigating scenarios online atm, so may need a little hand-holding!

Thanks all!

Mads

[June7]

Do you want macro or VBA?

Macro
Action: RunMenuCommand
Command: ImportAttachExcel

VBA
DoCmd.RunCommand acCmdImportAttachExcel

[Madraykin]

Ooooh - well, the macro is the format that I understand more! Thanks so much, I'll give these a go and see if they pan out!

[Madraykin]

The only issue I face with 'batch uploading' is one of the fields that normally auto-populate - ie. usually when a person's name is selected from a drop-down their contact details auto-populate, and when an address is selected the postcode is auto-populated.

I'm guessing this won't be possible via importing?

[June7]

The contact and postcode details autopopulate from where? This sounds like duplication of data.

No, the import wizard will not do that.

[Madraykin]

It is duplication of data - I've been having arguments with those I'm creating the database for over this. Tbh I think I'm going to change it anyway. It will save my struggling to find work-arounds that fit what they want!!

[June7]

Workaround would be to run UPDATE actions on the new records after imported.