hello
i would like to transfer one table[Product] from my SQL Server 2005 database to an excel and display the excel spreadsheet in vb2005.
Does anyone know how to do this?
Please help....
Thank you
User Profile
Collapse
-
sql to excel to vb and back
-
thanks so much :) i will try that -
Help with Like Query
Hello
Im trying to write a Like query to retrieve data based on a number. The table structure is as follows:
CustomerID CustomerName
1 John
11 Amy
When the user enters 1 i would like both records retrieved.
I have tried
SELECT *
FROM Customer
WHERE CustomerID Like ?
but if the user enters 1, it only brings... -
-
i have a datagrid with five rows filled with data. i only need one of those rows to show in a crystal report.
i have tried to do that but all the data from the datagrid is shown in the crystal report. im getting the data from sql server.Leave a comment:
-
crystal report problem
hi. im trying to select a row from a datagrid n only that row must show in a crystal report.
the code that im putting in is showing me all the information from the datagrid.
No activity results to display
Show More
Leave a comment: