VB Forum / Database Access / October 2005

How to use VBA to open a EXCEL(*.xls) file? Thanks for a example.   :)

I have just started programming in .net and have a SQL issue.
I have a "SELECT * INTO HOST FROM 105DW.dbo.HOST" statement that is driving
me nuts. I know that it has something to do with the 105DW naming of the db
because when I export it to DW105 and refer to it as DW105.dbo ...

How to write an executable file to call BCP command of SQL Server to export
tables to text files. Make a loop in vb codes, and you can catch or detect
the exception in the VB coding ?
A sample is appreciated!

I have a VB6/ADOX tool that has started returning an incorrect datatype for
VARCHAR columns in my SQL Server 2000 database. It now always returns adChar
(129) instead of adVarchar (200). It worked flawlessly ever since it was
first written, and now, on one machine only, it has ...

I've written a VB6 / Access 97 application and have run into a slight
snag.  I have designed a form to be used to add a new record to a
Contacts table.   The Contacts table is designed within Access to have
a key field of ContactID.  The ContactID field is set as data type of

I'm using VB6 to try and access a SQL Server database, but I cannot get
the following SELECT command to work when opening a Recordset:
"SELECT ClientID, FirstName, LastName, Relationship,
RelationToAcctOwner FROM AcctClient INNER JOIN NameAddr ON

I am a new to this group and Database i want to know about MSDE which i
saw in web control panel. Can any one help me.

Good Afternoon,
Upon arriving at this new contract, I was presented with a VB6 application
that had parts spread through numerous folders, undated .exe files, and a
mishmash in VSS6 among other problems.  I have found the relevant files in

Hi.. This is driving me crazy
I can connect and get data out of an access97 db that i created years
ago, but i cannot get anything out of a 2000 db that I created today.
I am running xp sp 2, with office 2003.  my msjet40.dll version is

VistaDB 2.1 embedded SQL database has been released. Free major update
features over 60 improvements including improved .NET Provider support
for Visual Studio .NET 2005, .NET 2.0 and .NET Compact Framework. 2.1
now includes a free 2-User VistaDB Server that extends the 500KB

hello every body
sorry now i have problem with
read BLOB from database and create new file
example that

I am using VB6 with DAO to execute a passthrough query to SQL Server, which
drops a table.  The first few times I execute this in code, there is no
problem, then it gets to a point where it cannot execute a 'drop table'
command.  It just sits there and times out.  I am thinking, ...

I have some beginners questions and i need some help.
This are questions for  the .NET Visual Basic. How can I make a form in
.NET visual basic and open it from another form because i know how to
make a main form but i cant make other forms. Or is there a way to open

I want to connect from VB6 (in Excel sheet) into SQL
This is my code
Dim cn as ADODB.connection
Set cn=new ADOBD.connection

I'm receiving the following error message (Item cannot be found in the
collection corresponding to the requested name or ordinal) when trying
to run the following:
SELECT Emedian("[Table Volume].RANKING, [Setup].RANKING","[Table