Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > query sql database
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 5
Default query sql database
Hello everybody

I need to import in a Excel sheet data from a Microsoft sql database,
I need the filtered data from some fields from one table and from a
other table which needs to be linked with a field the calculated sum from
the many related records.

Table one Table two, item nr.
field to be linked with table one

filtered
item nr-------------------------------------item nr / quantity
quantity
quantity
quantity
---------------------
sum

sheet result

item nr sum (quantity)

I can do everything except get the single result from the summed quantity
field

Anybody a idea how to achieve this?

Thanks

Walter










Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 1,588
Default query sql database
It might help if you could describe how you are doing what you have so far.

ADO?

Sounds like something along the lines of

select
table1.item_nr, sum(table2.quantity)
from
table1,table2
where
table1.item_nr = table2.item_nr(+)
group by
table1.item_nr

would do it, but I'm not sure of exact syntax for SQL Server

Tim




"Walter" wrote in message
...
Hello everybody

I need to import in a Excel sheet data from a Microsoft sql database,
I need the filtered data from some fields from one table and from a
other table which needs to be linked with a field the calculated sum from
the many related records.

Table one Table two, item nr.
field to be linked with table one

filtered
item nr-------------------------------------item nr / quantity
quantity
quantity
quantity
---------------------
sum

sheet result

item nr sum (quantity)

I can do everything except get the single result from the summed quantity
field

Anybody a idea how to achieve this?

Thanks

Walter












Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 5
Default query sql database
Hello Tim, thanks for answeing me

I programmed a lot years ago in superbase
but................................hahahahahaha
I start to learn again.
I recorded a macro in excel which looks like this

Sub test()

With ActiveSheet.QueryTables.Add(Connection:=Array(Arra y( _
"ODBC;DRIVER=SQL
Server;SERVER=PRODAC01\NAVISION;UID=marcv;APP=Micr osoft Office
2003;WSID=PRODAC01;DATABASE=NAV370BE;Trusted_Conne cti" _
), Array("on=Yes")), Destination:=Range("A1"))
.CommandText = Array( _
"SELECT ""Prodac$Item"".No_, ""Prodac$Item"".""Item Available Qty"",
""Prodac$Item"".""Sub Type"", ""Prodac$Item"".""Sub Sub Type"",
""Prodac$Item Ledger Entry"".Quantity" & Chr(13) & "" & Chr(10) & "FROM {oj
NAV370BE.dbo.""Prodac$Item"" ""Prodac$I" _
, _
"tem"" LEFT OUTER JOIN NAV370BE.dbo.""Prodac$Item Ledger Entry""
""Prodac$Item Ledger Entry"" ON ""Prodac$Item"".No_ = ""Prodac$Item Ledger
Entry"".""Item No_""}" & Chr(13) & "" & Chr(10) & "WHERE
(""Prodac$Item"".""Item Available Qty""$0) AND" _
, _
" (""Prodac$Item"".""Sub Type""='SS') AND (""Prodac$Item"".""Sub Sub
Type""<'WIRE')" & Chr(13) & "" & Chr(10) & "ORDER BY ""Prodac$Item"".No_" _
)
.Name = "Query from NavisionWalter"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With
End Sub

This is the SQL fom the microsoft query

SELECT "Prodac$Item".No_, "Prodac$Item"."Item Available Qty",
"Prodac$Item"."Sub Type", "Prodac$Item"."Sub Sub Type", "Prodac$Item Ledger
Entry".Quantity
FROM {oj NAV370BE.dbo."Prodac$Item" "Prodac$Item" LEFT OUTER JOIN
NAV370BE.dbo."Prodac$Item Ledger Entry" "Prodac$Item Ledger Entry" ON
"Prodac$Item".No_ = "Prodac$Item Ledger Entry"."Item No_"}
WHERE ("Prodac$Item"."Item Available Qty"$0) AND ("Prodac$Item"."Sub
Type"='SS') AND ("Prodac$Item"."Sub Sub Type"<'WIRE')
ORDER BY "Prodac$Item".No_

This outputs only one record from the quantity field, not the sum from all
the related quantity records which I need.

Can I change the SQL in microsoft query manualy? or Maybe I use the wrong
aprouch?

Thanks

Walter








"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
It might help if you could describe how you are doing what you have so
far.

ADO?

Sounds like something along the lines of

select
table1.item_nr, sum(table2.quantity)
from
table1,table2
where
table1.item_nr = table2.item_nr(+)
group by
table1.item_nr

would do it, but I'm not sure of exact syntax for SQL Server

Tim




"Walter" wrote in message
...
Hello everybody

I need to import in a Excel sheet data from a Microsoft sql database,
I need the filtered data from some fields from one table and from a
other table which needs to be linked with a field the calculated sum from
the many related records.

Table one Table two, item nr.
field to be linked with table one

filtered
item nr-------------------------------------item nr / quantity
quantity
quantity
quantity
---------------------
sum

sheet result

item nr sum (quantity)

I can do everything except get the single result from the summed quantity
field

Anybody a idea how to achieve this?

Thanks

Walter














Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 1,588
Default query sql database
You can edit the SQL manually. You need to use SUM() and GROUP BY if you
want to aggregate rows.

BTW, those field names (all those spaces!) should really be changed.
There's no reason to include spaces in DB identifiers.

Tim


"Walter" wrote in message
...
Hello Tim, thanks for answeing me

I programmed a lot years ago in superbase
but................................hahahahahaha
I start to learn again.
I recorded a macro in excel which looks like this

Sub test()

With ActiveSheet.QueryTables.Add(Connection:=Array(Arra y( _
"ODBC;DRIVER=SQL
Server;SERVER=PRODAC01\NAVISION;UID=marcv;APP=Micr osoft Office
2003;WSID=PRODAC01;DATABASE=NAV370BE;Trusted_Conne cti" _
), Array("on=Yes")), Destination:=Range("A1"))
.CommandText = Array( _
"SELECT ""Prodac$Item"".No_, ""Prodac$Item"".""Item Available
Qty"", ""Prodac$Item"".""Sub Type"", ""Prodac$Item"".""Sub Sub Type"",
""Prodac$Item Ledger Entry"".Quantity" & Chr(13) & "" & Chr(10) & "FROM
{oj NAV370BE.dbo.""Prodac$Item"" ""Prodac$I" _
, _
"tem"" LEFT OUTER JOIN NAV370BE.dbo.""Prodac$Item Ledger Entry""
""Prodac$Item Ledger Entry"" ON ""Prodac$Item"".No_ = ""Prodac$Item Ledger
Entry"".""Item No_""}" & Chr(13) & "" & Chr(10) & "WHERE
(""Prodac$Item"".""Item Available Qty""$0) AND" _
, _
" (""Prodac$Item"".""Sub Type""='SS') AND (""Prodac$Item"".""Sub
Sub Type""<'WIRE')" & Chr(13) & "" & Chr(10) & "ORDER BY
""Prodac$Item"".No_" _
)
.Name = "Query from NavisionWalter"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With
End Sub

This is the SQL fom the microsoft query

SELECT "Prodac$Item".No_, "Prodac$Item"."Item Available Qty",
"Prodac$Item"."Sub Type", "Prodac$Item"."Sub Sub Type", "Prodac$Item
Ledger Entry".Quantity
FROM {oj NAV370BE.dbo."Prodac$Item" "Prodac$Item" LEFT OUTER JOIN
NAV370BE.dbo."Prodac$Item Ledger Entry" "Prodac$Item Ledger Entry" ON
"Prodac$Item".No_ = "Prodac$Item Ledger Entry"."Item No_"}
WHERE ("Prodac$Item"."Item Available Qty"$0) AND ("Prodac$Item"."Sub
Type"='SS') AND ("Prodac$Item"."Sub Sub Type"<'WIRE')
ORDER BY "Prodac$Item".No_

This outputs only one record from the quantity field, not the sum from all
the related quantity records which I need.

Can I change the SQL in microsoft query manualy? or Maybe I use the wrong
aprouch?

Thanks

Walter








"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
It might help if you could describe how you are doing what you have so
far.

ADO?

Sounds like something along the lines of

select
table1.item_nr, sum(table2.quantity)
from
table1,table2
where
table1.item_nr = table2.item_nr(+)
group by
table1.item_nr

would do it, but I'm not sure of exact syntax for SQL Server

Tim




"Walter" wrote in message
...
Hello everybody

I need to import in a Excel sheet data from a Microsoft sql database,
I need the filtered data from some fields from one table and from a
other table which needs to be linked with a field the calculated sum
from
the many related records.

Table one Table two, item
nr.
field to be linked with table one

filtered
item nr-------------------------------------item nr / quantity
quantity
quantity
quantity
---------------------
sum

sheet result

item nr sum (quantity)

I can do everything except get the single result from the summed
quantity
field

Anybody a idea how to achieve this?

Thanks

Walter
















Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 5
Default query sql database
Hello again Tim



I have a SQL which works now, thank you, but I can not figure out how to
implement

this sql in the VB Macro, any examples?

If I make a smaller SQL I can do it in one line but this one is to big, I
tried all way's to breack

the lines like underscore etc but dont works, is the sql atatement it
regarded as one big text file in the macro?

What exactly did you mean with "those field names (all those spaces!) should
really be changed" ?

the sql should start under this line right?

.CommandText = Array( _



SELECT "Prodac$Item".No_, "Prodac$Item"."Sub Type", "Prodac$Item"."Item
Available Qty", "Prodac$Item"."Sub Sub Type", "Prodac$Item".Quality,
"Prodac$Item".Finish, "Prodac$Item".Thickness, "Prodac$Item".Width,
"Prodac$Item".Length, "Prodac$Item"."Net Weight", "Prodac$Item".Number,
"Prodac$Item".Construction, "Prodac$Item".Type, "Prodac$Item"."Last Direct
Cost", "Prodac$Item"."Vendor No_", Sum("Prodac$Item Ledger Entry".Quantity)
AS 'Vooraad'

FROM {oj NAV370BE.dbo."Prodac$Item" "Prodac$Item" LEFT OUTER JOIN
NAV370BE.dbo."Prodac$Item Ledger Entry" "Prodac$Item Ledger Entry" ON
"Prodac$Item".No_ = "Prodac$Item Ledger Entry"."Item No_"}

GROUP BY "Prodac$Item".No_, "Prodac$Item"."Sub Type", "Prodac$Item"."Item
Available Qty", "Prodac$Item"."Sub Sub Type", "Prodac$Item".Quality,
"Prodac$Item".Finish, "Prodac$Item".Thickness, "Prodac$Item".Width,
"Prodac$Item".Length, "Prodac$Item"."Net Weight", "Prodac$Item".Number,
"Prodac$Item".Construction, "Prodac$Item".Type, "Prodac$Item"."Last Direct
Cost", "Prodac$Item"."Vendor No_"

HAVING ("Prodac$Item"."Sub Type"='SS') AND ("Prodac$Item"."Item Available
Qty"$0) AND ("Prodac$Item"."Sub Sub Type"<'WIRE' And "Prodac$Item"."Sub
Sub Type"<'ROD')

ORDER BY "Prodac$Item".No_



Thanks again



Walter



"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
You can edit the SQL manually. You need to use SUM() and GROUP BY if you
want to aggregate rows.

BTW, those field names (all those spaces!) should really be changed.
There's no reason to include spaces in DB identifiers.

Tim


"Walter" wrote in message
...
Hello Tim, thanks for answeing me

I programmed a lot years ago in superbase
but................................hahahahahaha
I start to learn again.
I recorded a macro in excel which looks like this

Sub test()

With ActiveSheet.QueryTables.Add(Connection:=Array(Arra y( _
"ODBC;DRIVER=SQL
Server;SERVER=PRODAC01\NAVISION;UID=marcv;APP=Micr osoft Office
2003;WSID=PRODAC01;DATABASE=NAV370BE;Trusted_Conne cti" _
), Array("on=Yes")), Destination:=Range("A1"))
.CommandText = Array( _
"SELECT ""Prodac$Item"".No_, ""Prodac$Item"".""Item Available
Qty"", ""Prodac$Item"".""Sub Type"", ""Prodac$Item"".""Sub Sub Type"",
""Prodac$Item Ledger Entry"".Quantity" & Chr(13) & "" & Chr(10) & "FROM
{oj NAV370BE.dbo.""Prodac$Item"" ""Prodac$I" _
, _
"tem"" LEFT OUTER JOIN NAV370BE.dbo.""Prodac$Item Ledger Entry""
""Prodac$Item Ledger Entry"" ON ""Prodac$Item"".No_ = ""Prodac$Item
Ledger Entry"".""Item No_""}" & Chr(13) & "" & Chr(10) & "WHERE
(""Prodac$Item"".""Item Available Qty""$0) AND" _
, _
" (""Prodac$Item"".""Sub Type""='SS') AND (""Prodac$Item"".""Sub
Sub Type""<'WIRE')" & Chr(13) & "" & Chr(10) & "ORDER BY
""Prodac$Item"".No_" _
)
.Name = "Query from NavisionWalter"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With
End Sub

This is the SQL fom the microsoft query

SELECT "Prodac$Item".No_, "Prodac$Item"."Item Available Qty",
"Prodac$Item"."Sub Type", "Prodac$Item"."Sub Sub Type", "Prodac$Item
Ledger Entry".Quantity
FROM {oj NAV370BE.dbo."Prodac$Item" "Prodac$Item" LEFT OUTER JOIN
NAV370BE.dbo."Prodac$Item Ledger Entry" "Prodac$Item Ledger Entry" ON
"Prodac$Item".No_ = "Prodac$Item Ledger Entry"."Item No_"}
WHERE ("Prodac$Item"."Item Available Qty"$0) AND ("Prodac$Item"."Sub
Type"='SS') AND ("Prodac$Item"."Sub Sub Type"<'WIRE')
ORDER BY "Prodac$Item".No_

This outputs only one record from the quantity field, not the sum from
all the related quantity records which I need.

Can I change the SQL in microsoft query manualy? or Maybe I use the wrong
aprouch?

Thanks

Walter








"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
It might help if you could describe how you are doing what you have so
far.

ADO?

Sounds like something along the lines of

select
table1.item_nr, sum(table2.quantity)
from
table1,table2
where
table1.item_nr = table2.item_nr(+)
group by
table1.item_nr

would do it, but I'm not sure of exact syntax for SQL Server

Tim




"Walter" wrote in message
...
Hello everybody

I need to import in a Excel sheet data from a Microsoft sql database,
I need the filtered data from some fields from one table and from a
other table which needs to be linked with a field the calculated sum
from
the many related records.

Table one Table two, item
nr.
field to be linked with table one

filtered
item nr-------------------------------------item nr / quantity

quantity

quantity

quantity
---------------------
sum

sheet result

item nr sum (quantity)

I can do everything except get the single result from the summed
quantity
field

Anybody a idea how to achieve this?

Thanks

Walter


















Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 1,588
Default query sql database
Walter,

You might consider pasting your SQL into a worksheet cell and referencing
that in your VBA.
That would remove the need to manage those quotes and line-breaks.

..CommandText = Array(ThisWorkbook.Sheets("SQL sheet").Range("A2").Value)

My reference to your field names was just to mention that it is genrally
considered bad practice to create database identifiers (table/field names)
with embedded spaces. If nothing else, it makes writing SQL against the
database much harder. If you need "user-readable" field names then you
should just alias them in the SQL.

Eg:

select tablename.subsubtype as "Sub subtype"....

Tim

--
Tim Williams
Palo Alto, CA


"Walter" wrote in message
...
Hello again Tim



I have a SQL which works now, thank you, but I can not figure out how to
implement

this sql in the VB Macro, any examples?

If I make a smaller SQL I can do it in one line but this one is to big, I
tried all way's to breack

the lines like underscore etc but dont works, is the sql atatement it
regarded as one big text file in the macro?

What exactly did you mean with "those field names (all those spaces!)
should
really be changed" ?

the sql should start under this line right?

.CommandText = Array( _



SELECT "Prodac$Item".No_, "Prodac$Item"."Sub Type", "Prodac$Item"."Item
Available Qty", "Prodac$Item"."Sub Sub Type", "Prodac$Item".Quality,
"Prodac$Item".Finish, "Prodac$Item".Thickness, "Prodac$Item".Width,
"Prodac$Item".Length, "Prodac$Item"."Net Weight", "Prodac$Item".Number,
"Prodac$Item".Construction, "Prodac$Item".Type, "Prodac$Item"."Last Direct
Cost", "Prodac$Item"."Vendor No_", Sum("Prodac$Item Ledger
Entry".Quantity)
AS 'Vooraad'

FROM {oj NAV370BE.dbo."Prodac$Item" "Prodac$Item" LEFT OUTER JOIN
NAV370BE.dbo."Prodac$Item Ledger Entry" "Prodac$Item Ledger Entry" ON
"Prodac$Item".No_ = "Prodac$Item Ledger Entry"."Item No_"}

GROUP BY "Prodac$Item".No_, "Prodac$Item"."Sub Type", "Prodac$Item"."Item
Available Qty", "Prodac$Item"."Sub Sub Type", "Prodac$Item".Quality,
"Prodac$Item".Finish, "Prodac$Item".Thickness, "Prodac$Item".Width,
"Prodac$Item".Length, "Prodac$Item"."Net Weight", "Prodac$Item".Number,
"Prodac$Item".Construction, "Prodac$Item".Type, "Prodac$Item"."Last Direct
Cost", "Prodac$Item"."Vendor No_"

HAVING ("Prodac$Item"."Sub Type"='SS') AND ("Prodac$Item"."Item Available
Qty"$0) AND ("Prodac$Item"."Sub Sub Type"<'WIRE' And "Prodac$Item"."Sub
Sub Type"<'ROD')

ORDER BY "Prodac$Item".No_



Thanks again



Walter



"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
You can edit the SQL manually. You need to use SUM() and GROUP BY if you
want to aggregate rows.

BTW, those field names (all those spaces!) should really be changed.
There's no reason to include spaces in DB identifiers.

Tim


"Walter" wrote in message
...
Hello Tim, thanks for answeing me

I programmed a lot years ago in superbase
but................................hahahahahaha
I start to learn again.
I recorded a macro in excel which looks like this

Sub test()

With ActiveSheet.QueryTables.Add(Connection:=Array(Arra y( _
"ODBC;DRIVER=SQL
Server;SERVER=PRODAC01\NAVISION;UID=marcv;APP=Micr osoft Office
2003;WSID=PRODAC01;DATABASE=NAV370BE;Trusted_Conne cti" _
), Array("on=Yes")), Destination:=Range("A1"))
.CommandText = Array( _
"SELECT ""Prodac$Item"".No_, ""Prodac$Item"".""Item Available
Qty"", ""Prodac$Item"".""Sub Type"", ""Prodac$Item"".""Sub Sub Type"",
""Prodac$Item Ledger Entry"".Quantity" & Chr(13) & "" & Chr(10) & "FROM
{oj NAV370BE.dbo.""Prodac$Item"" ""Prodac$I" _
, _
"tem"" LEFT OUTER JOIN NAV370BE.dbo.""Prodac$Item Ledger Entry""
""Prodac$Item Ledger Entry"" ON ""Prodac$Item"".No_ = ""Prodac$Item
Ledger Entry"".""Item No_""}" & Chr(13) & "" & Chr(10) & "WHERE
(""Prodac$Item"".""Item Available Qty""$0) AND" _
, _
" (""Prodac$Item"".""Sub Type""='SS') AND (""Prodac$Item"".""Sub
Sub Type""<'WIRE')" & Chr(13) & "" & Chr(10) & "ORDER BY
""Prodac$Item"".No_" _
)
.Name = "Query from NavisionWalter"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With
End Sub

This is the SQL fom the microsoft query

SELECT "Prodac$Item".No_, "Prodac$Item"."Item Available Qty",
"Prodac$Item"."Sub Type", "Prodac$Item"."Sub Sub Type", "Prodac$Item
Ledger Entry".Quantity
FROM {oj NAV370BE.dbo."Prodac$Item" "Prodac$Item" LEFT OUTER JOIN
NAV370BE.dbo."Prodac$Item Ledger Entry" "Prodac$Item Ledger Entry" ON
"Prodac$Item".No_ = "Prodac$Item Ledger Entry"."Item No_"}
WHERE ("Prodac$Item"."Item Available Qty"$0) AND ("Prodac$Item"."Sub
Type"='SS') AND ("Prodac$Item"."Sub Sub Type"<'WIRE')
ORDER BY "Prodac$Item".No_

This outputs only one record from the quantity field, not the sum from
all the related quantity records which I need.

Can I change the SQL in microsoft query manualy? or Maybe I use the
wrong
aprouch?

Thanks

Walter








"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
It might help if you could describe how you are doing what you have so
far.

ADO?

Sounds like something along the lines of

select
table1.item_nr, sum(table2.quantity)
from
table1,table2
where
table1.item_nr = table2.item_nr(+)
group by
table1.item_nr

would do it, but I'm not sure of exact syntax for SQL Server

Tim




"Walter" wrote in message
...
Hello everybody

I need to import in a Excel sheet data from a Microsoft sql database,
I need the filtered data from some fields from one table and from a
other table which needs to be linked with a field the calculated sum
from
the many related records.

Table one Table two, item
nr.
field to be linked with table one

filtered
item nr-------------------------------------item nr / quantity

quantity

quantity

quantity

---------------------

sum

sheet result

item nr sum (quantity)

I can do everything except get the single result from the summed
quantity
field

Anybody a idea how to achieve this?

Thanks

Walter




















Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import New Database Query (Union Query) in Spreadsheet klock Excel Discussion (Misc queries) 2 September 24th 09 01:30 AM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 1 November 29th 05 01:44 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 0 November 28th 05 06:37 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement