Excel importing

[readingr]

I want to import a spreadsheet into microsoft access 2007. I know I can do this by going into "external data" then to import but I don't want to do it that way.

Instead, I would like to create a button on a form which when clicked, will start up the import wizard which is clicked in "external data".

How could I do this?

Thanks.

[ADezii]

I want to import a spreadsheet into microsoft access 2007. I know I can do this by going into "external data" then to import but I don't want to do it that way.

Instead, I would like to create a button on a form which when clicked, will start up the import wizard which is clicked in "external data".

How could I do this?

Thanks.

Not the cleanest or prettiest approach, but it do work:

SendKeys "%FG", True
SendKeys "I"