15. oktober 2004 - 11:00Der er
19 kommentarer og 1 løsning
Sammenkæd excel ark
Hi all,
sorry for writing in english, written Danish is not that good, but feel free to write your response (if any) in Danish.
Here is my problem.
I have one excel file, with many sheets, all the sheets contain the same headings. e.g. each sheet contains customer number and customer name. The numbers may be the same in each sheet as well as the name. so they are not unique.
I can link one sheet to access, but how do i link all of the sheets to access and link those sheets together into a table, then i will link that table to the database.
The problem is that you can only link one table to one database. so i need to link all of the sheets together before i can link it to the db.
So basically when someone updates/alters a sheet in the excel file it will update it in access.
Can i link multiple sheets together ? to create one master tabel that also gets updated when the sheets do ?
If you do not understand what it is that i am asking just let me know and i will try to re-formulate the question.
i have linked all the sheets into seperate tables. Bit of a noob on the old access, so where would i execute this SQL ? After the data is presented in one table, can it be linked to the db, if so, will this table be updated when the other sheets/tables are altered ?
Having some problems finding my way around in this Danish version of Access, can you elaborate on the above so i can find my way round to run this query ?
Switch to the tab named "Forespørgsler" and create a new Query using the button "Ny"->Designvining->Luk Go to menu Vis->SQL-visning and enter the SQL statement. Close and save.
ah "Forespørgsler" that seems to be the one. Now am just getting errors on the SQL statement but that was not the question. so here are the points minus 20 till i have checked to see if the updates in excel flow through ;) cheers for you help. and onwards with sql errors. just not my day today.
It's your "12 md", that Access is having problems with. Names with spaces and special signs needs []:
SELECT * FROM [12 md] UNION ALL SELECT * FROM net
Or even shorter: Table [12 md] UNION ALL Table Net
no I didn't get any points, but you properbly need to click on my name in the box to the left before hitting the "Accepter"-button (you are not the only one, having problems with that!)
yeah it just occured to me that was the problem. after askin all these questions i think me brain just shut off.
Can this query be linked to a database ? the final part of my problem, getting it linked to a database. or do i throw this query into another table and then link that table to the db ?
another program will be pulling data out of this combined data. need all the data from the various sheets in one large table, that is updated when the excel is updated. then the other program will look in this large list for what it needs.
sorry, I didn't realize that! You can't link to a query from another program using direct link. Then you must use VB and ADO or DAO to do so. And thats more complicated :o(
i see problems everywhere :) well thanks for your help on the issue of getting it all together. guess i am gonna have to VB my way around the last issue.
Thanks again for you help and as far as the points go, they're all yours
have a good weekend.
maybe arsenal will loose this weekend, one can only hope.
hehe, good luck on the game, and you have a good weekend too :o)
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.