as I stated before. it is in MS ACCESS. all the code there is using dao.

while I used this. myConnection is not defined.

Set cmd = New ADODB.Command

Set cmd.ActiveConnection...

I tried what mark suggestion ,

something like : put the chr etc. it did not work.

strM = "(RehiredStatusMailingList.SUPERVISOR= " & Chr(34) & strM & Chr(34) & "' or RehiredStatusMailingList.MANAGER="...

Thank you for your time. It is in MS ACCESS. I have combo box which is working fine if the combo text is just text without special character. One person's...

It is fix width file and suppose to have six fields to import. the first column would be field name.

see attached test file.

PID SPECIALTY PNAME ...

USE [Clinical_Edu_2006]

DROP TABLE Doc

GO

GO

/****** Object: Table [dbo].[DOC] Script Date: 06/17/2009 13:58:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[DOC](

[PID] [char](17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SPECIALTY] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PNAME] [char](55) COLLATE...

my file is like that.

PID SPECIALTY PNAME ...

I set that as link table right now. It should solve the problem.Thx.

I do not think I understand that quoto well. in the report table name field.

I have those data in the access table

"Abu Al-Hasan Al Madani"

I need to take off the...

thx. how to explain this syntax:

"""" I assumed this " is escape. Thx.

but it is in MS ACCESS. I tried to put single quote. It did not work.

I want to check whether the begining of the data is "

for this case "STICHTING WERELDHULP-BELGIE

select left([name], 1) from table1 where left([name], 1) =" " " and right([name],...

How can I write select statement for

the data beginning with "

"STICHTING WERELDHULP-BELGIE

and data ending the sentence ?

V.Z.W."

Thx.

Source is the column name. I still do not understand Source&1 or Source&2 here.

Select

PartyId,

FirstName,

LastName,

^{Case when Source&1<>0 then 1 else 0 End[Source1],}

Case when Source&2<>0 then 2 else 0 End[Source2],

Case when Source&4<>0 then 4 else 0 End[Source3],

AddDate,

ModDate

from dbo.ExistingMaster

Will you please let me know what...

what ever do you get ?