Combining datasources Access/Excel

  • Thread starter Thread starter Alex F. Buiel II
  • Start date Start date
A

Alex F. Buiel II

I'm having brain lock. I have set up an Access database and linked to
external datasources - namely an Excel spreadsheet and another Access table.
Both have date, product source, and product code columns. I need to combine
data from both sources into a single table with the above-mentioned columns
so that a single table now contains data from both sources, aggregated into
the 3 fields.

I know the answer is simple, I just am drawing a blank.

Thanks,
Alex F. Buiel
 
Alex,

Create a new table with the same fields. Use an Append query to append the data
from the Excel spreadsheet to the new table. Then use an Append quer to append
the data from the Access table to the new table.
 
Thanks. I'll give it a try.

--
Alex

| Alex,
|
| Create a new table with the same fields. Use an Append query to append the
data
| from the Excel spreadsheet to the new table. Then use an Append quer to
append
| the data from the Access table to the new table.
|
|
| --
| PC Datasheet
| Your Resource For Help With Access, Excel And Word Applications
| www.pcdatasheet.com
|
|
|
| | >
| > I'm having brain lock. I have set up an Access database and linked to
| > external datasources - namely an Excel spreadsheet and another Access
table.
| > Both have date, product source, and product code columns. I need to
combine
| > data from both sources into a single table with the above-mentioned
columns
| > so that a single table now contains data from both sources, aggregated
into
| > the 3 fields.
| >
| > I know the answer is simple, I just am drawing a blank.
| >
| > Thanks,
| > Alex F. Buiel
| >
| >
|
|
 
Back
Top