Tereesa has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel - Getting data in from Access
Hi,
I have an issue regarding data link between Excel and Access.
I am using the “Get external data” function to import quite large amount of data from Access. My problem is that i have two data tables from 2 different Access tables and i need to merge them in excel. To explain: table 1 consist of columns A,B,C,D,E and table 2 has columns A,B,F,G - so there are some columns that overlap.
Ideally i would like to have this data in one Excel sheet with columns A,B,C,D,E,F,G (basically if the data was not so large i could just copy-paste the two tables one underneath the other and the use pivot table to get the necessary column to be ‘next to each other’ ).
Is there any way to bring in data from two sources and merge it into 1 table? Or to 1 pivot table?
Many thanks
RE: Excel - Getting data in from Access
Hi Tereesa, thanks for your query. The trick is to create a query in Access to combine the fields you want. Then use Get External Data in Excel as usual and point it at your query during the import process.
Hope this helps,
Anthony
RE: Excel - Getting data in from Access
HI, thank you for the answer, however i have tried it and it didn’t work.
The problem is that in one table the dates range from way in the past to present month and in the other table the dates go from January present year to future (2035 and further) so there really only area couple of overlapping months.
The access query started to repeat values for all months for some reason.
Is there any other solutions?
