VB Forum / Database Access / November 2005

     I am exporting the contents of two tables to excel spreadsheets with
the following:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Production
Data", "C:\archive\Prod.xls", True, "" 'Export the Production Data Table

I am writing an app in VB6 to search an Access 2000 MDB file. I want to have
it look through the records (in a single table) for a particular "keyword"
or "keyphrase" or
whatever the user puts into the text field.

We have created a program in VB 6.0 with a reference to DAO 3.6 because one
of our customers had problem connecting to the database with a reference to
DAO 2.5/3.51.  He has Office 2003 installed on his computer.
He is now able to connect to the database, but now, when he tries to ...

I need to export a SQL database to an excel file using asp code. Could
any one help?? I see a lot of messages about it but could not find a
solution. Please help.
Thank you

I have a problem with dataGrid. I have a query to database and it returns me
to datagrid, something like this:
--------------------

I have a SQL Shape command which gets account records, containing a child
query which gets transactions belonging to the accounts.  I use this to
populate a hierachical grid.  The problem is I want to specify a range of
accounts, and a range of transactions within the accounts eg ...

What is the "best practice pattern" for executing in-line SQL code
against attached tables ?
Especially ... Managing connections to those attached tables ?
Architecture is multi-user VB App connecting to SQL Serve via tables

I have a disconnected ADODB recordset in my VB6 application.
What I want to do is to display the data to the user and allow them to
select a subset of rows.  This subset tells the application which rows it
must do something to and which ones it must leave alone.

I have an application that I am tryign to modify, I never wrote the
original so need help with my modifications.
Currently the app reads and writes to an Access database with one table
'pupils' I would like to keep this table but only ever update the