import nultilinkage sql table into excel

[Masita]

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.

 

[pietlinden]

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.

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.

 

[Masita]

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

 

[pietlinden]

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

--
masita







- 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.