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

Autonumber field in Excel that behaves the same as Access 0
Embed the same Excel multiple times 0
Adding data to MS Access from csv file 0
VBA to extract data from 2 excels 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Integrating information from Word to Excel (not mail merge) 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Appending an existing table with imported Excel data 0

Top