import nultilinkage sql table into excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Masita - 05 Mar 2007 11:02 GMT

hi all,

Again i have problem to import my sql table from Excel 2002.
I intend to import few joining table and expected a data from the joining
table as a result into my excel file.

How can i do that ? Using Import external data, i only can import one by one
all my sql table without any linkage for each of the tables.

Kindly please advice.

--
masita

Reply to this Message

pietlinden@hotmail.com - 05 Mar 2007 21:34 GMT

> hi all,
>
[quoted text clipped - 9 lines]
> --
> masita

that's vague... what database are you using? SQL Server? Sounds like
you need to create a query/view in Access/SQL Server and then output
that to excel. But it's hard to tell from your description.

Reply to this Message

Masita - 06 Mar 2007 00:51 GMT

Yes, its is SQL database.
How to create in query ?

--
masita

>> hi all,
>>
[quoted text clipped - 14 lines]
> you need to create a query/view in Access/SQL Server and then output
> that to excel. But it's hard to tell from your description.

Reply to this Message

pietlinden@hotmail.com - 15 Mar 2007 21:33 GMT

> Yes, its is SQL database.
> How to create in query ?
[quoted text clipped - 26 lines]
>
> - Show quoted text -

If this is a SQL Server database, you'd probably be better off asking
in the SQL Server groups. If this is an Access question, I think we
need more information - you probably have to attach the Excel file
temporarily and query the various columns and append them to the
relevant columns in various tables. But without looking at your data,
it's impossible to tell for sure.

Reply to this Message