VB Forum / Database Access / April 2006

How do I load a text file or a csv file into a Datagrid using vb6?

A project I am working on uses the DTPicker, ADO, and M$ Jet.  The
project will be used world wide (hopefully).  I want to have one
instance of DTPicker to handle Date and Time.  This can be done by
checking the checkbox, checking the UpDown, and selecting Format =

Anybody can tell me what is the ADO connection string parameter for PROGRESS
9.1B and 9.1C database please?

For a project i have to create a travel agency program, using a
database. im using access 2003 as my database. im having problems with
my code its when i execute this line "
objFlightOut.Update(objDataSetOut, "Outbounds") " that i get an error

I am trying to fill a text box with with values that i get from a query. i
can get the string into the textbox but it is not what i want to show. For
example what i get is "43668 t/3" what i want is "43668". is there away in VB
that i can only return upto the first space?

I'm a newbie to MS Access. I have a table with email addresses.  What's
the best way to parse each email using a Left(),Right(), or InStr()
function so that the data returns the domain of each email (everything
after the @ sign)?

How can I create an Access MDB database file from within VB6 using the
results of multiple ADO recordsets to add tables to the file? The records are
coming from a SQL database.
Thanks

Hi all...
Can any one help with this one?
When highlighting an ADO keyword in Access97, it displays an error "Cannot
locate ADO270.CHM"......

I'm trying to build a simple application in VB6 that will take data
from 3 tables in an access 2000 db and write it into an existing Oracle
9i database.
What is the easiest way to do this? I have a connection set up for the

Can someone tell me what I'm doing wrong here?
I have a procudure that adds a purchase order number to an Access 97
database.  If the number already exists, the procedure throws an error,
which is handled in the following code:

i have problem running dts package through vb on client machine where
SQL server is not installed. my code is running properly in server
machine or in machine where SQL Server is installed. but how can run it
in client machine.

I have searched in newsgroup for the following error and found nothing
which can help me.
Two people are working together with an visual basic application in one
database. The database is access 2000 and visual basic makes an

I have a client who has been using an application since 2002 with no
connection problems.  Monday of this week they went to use the application
and it would not connect to the database.
It is a VB Application that uses an ado to connect to an access database.  I

I need to count all records where a certain field is empty (null). How can i
do this as quick as possible. (it's not a very large database).
I'm new to database programming, so i appreciate an example.
Robertico

Ok here's the problem, first time i saw that
i run a query in vb6 with the connection
cnconn.execute("the query")
the query is a insert. i made it directly on vb first after i tried it