VB Forum / Database Access / December 2003

I am going to import a text file into SQL Server using VB6, I tried to
use INSERT BULK, but due to the fact that the column width is fixed, I
need to somehow specific the width, is there a way to do it within the
INSERT BULK statement. In fact, each field in the table of the SQL

I have a VB application in which one form uses a datagrid to change a
Product recordset, and a 2nd form uses a flexgrid to display a
ProductAndMfgr recordset, a join between the underlying product data and a
manufacturer database. Both recordsets are commands coming off a single

From my VB6 app I would like to open an Access Database
and import a text file (comma delimeted) into an existing
table. From within Access I could do this, i.e.
TransferText method, but does anyone know how it can be

Bonjour,
Je suis surtout utilisateur du C++ (dans Visual C++) et du
Pascal (dans Delphi), ceci explique peut-être pourquoi
VBA me donne quelques soucis!

Referring to E-mail of Nov 26 2003 1:44AM:
"Database on a LAN"
I Studied something about MSDE.I'm trying to develop some
example applications:

I am attempting to allow a user to cancel an ADO delete
Operation during mid-execute.  I've tried dozens of
options, but I'm getting nowhere.
Set cnn1 = New ADODB.Connection

I am having a concurrency problem with an VB DLL which uses ADO to access a
remote SQL database.
Scenario:
Free threaded VB.NET client used to execute a function in the VB dll and

All,
I need to insert specific Excel worksheets in one workbook into Word.
I believe this should be straightforward, but I cannot find (or figure
out on my own) how to reference the worksheet.

hi I hope someone can help me with this..
I am using the Data Environment in VB to execute an ADO command which requires a parameter as follows
gdsrDE.cmdGetClientsByName SrchName
Set rs = gdsrDE.rscmdGetClientsByNam

I've written a VB6 application which populates a table.  I
am contemplating adding a column to the table which 95% of
the time will be null but the other 5% of the time can be
a character string of up to 100 characters.

I am doing some research on backwards compatibility in ADO. The MS
site lists the 3 latest versions available for download: 2.6, 2.7, and
2.8. If I install the latest release, am I in any danger of breaking
interfaces on apps the were coded and installed with prior versions ?

can any one help me please
I am using ado in VB 6 , I have a database on Access XP, everything is fine,
But when I make setup, the error "an error occured while registering the
file msado25.tbl " occured and I cant run the program , is there any

I wish to ADD rows to a large (200 fields x millions of
rows) SQL Server table using an ADODB.recordset. I want to
open the recordset in a way that no rows are returned,
only metadata.

I'm working on an aplication that is linked with an Access database, I
interact with SQL commands with.
The problem is that I've many filed for filling as many tables too.
I'm currently using a Dataenvironment as well as Adodc's. But

I have the following math problem for someone to help me figure out:
Within my SQL Server database, the time is stored as a long integer.  Don't
ask me why--this is just the way it is done.  The format is the sum of the
hour in 24-hour notation scaled by 10000, the minutes scaled by ...