Import data from access into excel where one column go into one worksheet and other into next

Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.