Prev: save OLE Object to a file
Next: Comparing the data in between two worksheets and pasting the data in next worksh
From: Laura on 19 Jan 2010 04:44
Can anyone recommend a good little online tutorial so that I can get
started with manipulating my excel SQL queries. I have managed so far
to link up excel to the database and pull out a table, add in some
criteria (ie dates etc), applied a sort field and refresh. However I
want to understand a bit more about how to pull out two tables and
link them together, and this is where (as a beginner) I am getting
stuck. I do not need an intense SQL certification course or anything
like that, just a tutorial about how to edit and manipulate SQL
queries in excel. If anyone can point me in the right direction I
would be grateful, everything that I have found so far is way beyond
what I need to do technically.
From: Bob Phillips on 19 Jan 2010 06:53
What are you suing for the query, MS-Query or ADO?

If the former, isn't there a wizard to guide you through that?

HTH

Bob

"Laura" <lvlandmark(a)gmail.com> wrote in message
news:16d4a410-892a-4cb6-a5e2-9e271dd9c932(a)l30g2000yqb.googlegroups.com...
> Can anyone recommend a good little online tutorial so that I can get
> started with manipulating my excel SQL queries. I have managed so far
> to link up excel to the database and pull out a table, add in some
> criteria (ie dates etc), applied a sort field and refresh. However I
> want to understand a bit more about how to pull out two tables and
> link them together, and this is where (as a beginner) I am getting
> stuck. I do not need an intense SQL certification course or anything
> like that, just a tutorial about how to edit and manipulate SQL
> queries in excel. If anyone can point me in the right direction I
> would be grateful, everything that I have found so far is way beyond
> what I need to do technically.


 | 
Pages: 1
Prev: save OLE Object to a file
Next: Comparing the data in between two worksheets and pasting the data in next worksh