Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-02 : 07:27:31
|
| Kaustubh writes "Hi,I am using MS Access. I have a few CSV files that I have uploaded into say, A1.mdb, A2.mdb and A3.mdb (need to do this: A1 having data from say 1st of a month to 10th, so on and so forth). Now, these have been linked into another database B1.mdb, as linked tables. I need to write a query, so as to return values from all these tables. How do I go about it?Look forward to your replies.Thanks,K" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-02 : 08:49:37
|
| Look into the UNION phrase and create a VIEW which will link the multiple resultsets back into 1 unified dataset. THen you can apply PIVOTS to the VIEW. |
 |
|
|
|
|
|
Pivot tables in MS Access