ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   connecting to databases (https://www.excelbanter.com/excel-discussion-misc-queries/43767-connecting-databases.html)

dstiefe

connecting to databases
 
can anyone suggested a good textbook to learn how to use excel to connect to
databases.

Also a good book to learn about the basics of databases?

Any suggestions with learning this material would be greatly appreciated.

for example some people have suggested learning more about SQL than MS Access?

Your input would be greatly appreciated

Thank you

Ed Ferrero

Hi dstiefe,

A tutorial here on using pivot tables connected to databases.
http://edferrero.m6.net/tutorials.shtml

My suggestion for learning databases - start with Access.

Ed Ferrero
http://edferrero.m6.net/


can anyone suggested a good textbook to learn how to use excel to connect
to
databases.

Also a good book to learn about the basics of databases?

Any suggestions with learning this material would be greatly appreciated.

for example some people have suggested learning more about SQL than MS
Access?

Your input would be greatly appreciated

Thank you





All times are GMT +1. The time now is 02:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com