How to import data from Access into a Current Worksheet

A

Ankit Parikh

Hello Everyone
I m not sure if this is the right place for my query?
I am a studrnt and I am doing an assignment in which I have to import data
into Excel worksheet.Now this data needs to be appended to the existing data.
The problem is that Data that i am importing is only 10 fields and the
worksheet has 19 fields. I tried using the import wizard but it just pastes
the data on the worksheet,not in the proper fields or cells.
How can I import data into its specific fields?
Also My Insert Query does not work with excel?
It works fine with Access?
Please help me or direct me to the right group.
Ankit Parikh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top