VB Forum / Database Access / December 2003

i have a excel sheet with chiness characters, i want to
insert that data into SQL server using VB application.
i wrote a small connection to excel and sql server,reading
excel (load sheet in recordset) and update the sqlserver.

I have a customer table, a customer_services table and a services
table,
I want to use the shape command to generate the parent child
relationship of customers and the services they have, and to do this I

I have a series of COM objects written in VB that are being called by
ASP pages. These COM object use stored procedures in SQL Server 2000.
I'm using ADO and OLEDB to connect to SQL Server with the following
connection string:

Hello, I have a table which has duplicate records (based on account number.
I am looking for some code which will loop thrould the table (or query) and
identify and delete the dups.  Obviously I can run a delete query on the
dups, but this will delete all dups.  I am looking for ...

I am writing a VB server that will query a SQL Server 2000
database for various data.
The VB server will run on a separate box from the database
server.

From VB.NET, I am passing two date parameters, @DateFrom
& @DateTo to a stored procedure on SQL 2000 Standard.
Both are defined the datetime datatype.
The stored proc simply does the following

What function can i use in SQL 2000 instead of the following invalid Format
function?
Select   Format( AMOUNT, '###,###' ) as AMT  From  ORDER

I have developed an application in VB 6.0 (w/ sp5) using
an Access 97 database.  This network application has been
running w/o any problems for several years.  In the last
few months, error 3343 is generated several times a day.  

I have a problem while saving data in to access table,
this is because in one of the field value Single Quote is  
present. The presence of quotes is valid for that field.
But during save this creates a problem, Is there any way

I use A97 but have recently needed to write a db for  useing VB6, cos the
machine its going on uses A2000.
In A97 i could write
----

Hope you can see past my table, string definitions (Swedish), just ask
otherwise
Having some problem with a SQL statement
I need to be able to run strSQL3, but I get an error about sum and that I

Hai all,
Can any help me on this issue.
I wnat to know how can i create a table in access 2000
with the datatype as decimal.

I am having a bit of difficulty doing this code in vb6.
What I am trying to do is locate a certain field in a table attached to an
msflexigrid, and check the contents of that particualr field.
The filed is call ocument path, and I want to check to see if that field is

Heres the deal.  I am sorting a recordset that I created
and it is being displayed in a datagrid.  I set the
recordset.sort property to the correct field name and
ASCENDING. Ex.

i am writing my first vb program. the program retrieves
data from an access table. my problem seems very simple:
how do i get vb to recognize quotation marks as
characters within a sql string rathe than then end of a