Connection Between Excel and Other Database software

**BS Singh** · 01-31-2015, 10:56 AM

Hi,

I would like to store data in Access and whenever required I would like to fetch data in excel for reporting and analysis purpose.

Could somebody please help me understand the basics of this.

Also I am new to SQL and i heard that a connection can be established between SQL and Excel so would like to know which version of SQL is best for reporting purpose?

So far my understanding is SQL server is the software and SQL is the language to perform action on data stored in database. I am interested to learn SQL so please help.

Regards,

**BS Singh** · 01-31-2015, 01:35 PM

Could somebody please look into my request and help?

Let me know if more explanation is required.

Regards,

**Brendan_Floyde** · 01-31-2015, 02:26 PM

I'd start here.......

https://support.office.com/en-ca/art...8-4c62f252da2e

**AB33** · 01-31-2015, 03:38 PM

SB,
Do not go deep in to technical side of SQL, SQL server and the rest. This can only compound your confusion.
I have read in a book where the author goes to the extent that SQL does not stand for "Structured Query language"
If you talk to hard-core programmers, they will not classify SQL as a "sub routine language, but a language"
Access is the easiest tool to learn how to use SQL commands(Queries). Access has a sample tables. You can use these tables for practice. You can view the SQL code, it is similar to recording your macro code in excel.
Broadly speaking, there are two ways to extract(Link) excel and other databases(Like Server). Direct from excel functions (through Data) and writing your own code.
If you write your own code, the format of the syntax is similar to copying data from a folder in excel (open a folder), but you need to connect to Access through ADO. You can use either Early or Late binding. The most commonly used command in SQL is "SELECT"
You can do your data manipulation in "Access", view the SQL syntax and copy it in to excel. The challenge is to change your set of mind. Access and excel are not the same and operate differently.