VB Forum / Database Access / February 2005

I've got a weird problem  - - - it must be something simple, but for the
life of me, I must be missing it...
I've got a recordset - and I'm trying to add the results into a listview,
but, instead of adding each successive record after the first line of the

Help! :(
Is there a way to automate the importation of a text file in to VB,
with out having to use the import text wizard every time?
Below is a sample the the file and the inofrmation I need. ( the file

My requirement is to build 3-tier architecture.
I am using ADO 2.7, and able to execute single SQL and stored procedure. But
when i am trying doing the same with the RDS feature of ADO It suporrts
single SQL execution but not the stored procedure. whenever i am trying to

I am using ADODatacontrol in my form, when I link TextBox with ADODC it
shows me the records, but when I link this ADODC with ListBox it does not
show any data. Please advice.

Dear,
I have developed a standalone VB6.0 application which uses an access
database. I deployed this application with the "Package &
Deployment"-wizard from Visual Basic, and it works fine.

I hope that someone can help with a this problem:
I have a table containing 5 different records and I want to print out only
those records which met a given condition.
My code is similar to this where mydata1,2 and 3 represent data held in 3

I know how to get data from the database, but how to put the result to a text
file (.csv)?  The idea is when the user clicks the 'result' button, it should
generate a .csv file with the query result.  Thanks!

Dear fellow programmers,
      With vb6, i am using MS Access as my database. I already made a lot
of reports in the MS Access and i want to access that reports too in my vb6
program. My vb6 program should be able to view and print those MS Access

As said: my app lets users select records.
They can choose to delete the whole current selection.
i tried rs.delete, but that gave me an error.
Primary keys are in available in recordset.

I've managed to set up an MSHFlexGrid and store it with data from an Access
DB successfully.
What I'm trying to do is retrieve data from a selected row but I'm not sure
what methods I need to call to get this data.

We have an app that connects as a certain user (limited rights for normal
operation) to a SQL Server 2000 database running on the local machine.  Its
actually MSDE, but whatever.
When we want to push out database updates, or to be able to run a backup and

I am trying to get information from one excel file to the current one. I have
to select a couple of columns and import onto the current excel file.
With cmdCommand
   .CommandText = "SELECT `'Sheet2$'`.Step_Index, `'Sheet2$'`.`Voltage(V)`"

i've got a table in a access file, and i want to display a number on a
form, displaying a total unmber of a record.
e.g. i have a table with paper submissions, and i want to display the total
number of submissions. and i want to do it as a click event. how do i do

A customer upgraded my program on an XP machine with Service Pack 2.  The
upgrade now uses msadodc.ocx and when the program hits the line of code that
says "Set datLog.Recordset = rsLog" the program fails with a "Error loading
dll" and nothing else.  Help?  I've tried re-registering ...

Is the following code correct to call the ado-connection from every form i
create. I'm getting errors if i execute it.
For testing purposes i used the code in the form's module and then it
worked, but not how i like it. The purpose of it, is to use connection