Import Blank fields from Excel

S

shalini.kupparaju

Hi in a problem with excel,

I have a Access link already created with an Excel1 , this table has a
few columns blank. The data for these columns need to be imported from
a diff excel Excel2, How do i go about doing the same , As i am all
confused . Please help.

Thanks in advance
shalini
 
J

John Nurick

Hi Shalini,

Link the second worksheet as another table, and then use a query that
joins the two tables as required.
 

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

Similar Threads

Showing information from an excel document to another excel docume 3
Excel merge or synchronize 2
Import excel file in outlook calendar 0
import excel data - scientific notation 1
Import Several excel files into Several Access Tables 6
Access-Excel Import Wizard problem 1
Importing fields from separate excel sheets to fill in info in dba 3
Help with selective import from Excel. 4

Top