It looks like NIR_INPUT.SAMPLE and NIR_INPUT1.SAMPLE have dishomogenous data types

@RF

Your posts are a real treasure trove of information 🙂

"There are On Startup and On Shutdown events available for the Access object that would allow this."

Can you please point me to where, on Access help, it mentions these two...

What are Synonyms?

What does E2E stand for in

E2E.SchemaTest

?

I'm looking at the ALTER TABLE statement in Access help; where does it say you can use TRANSFER in its syntax?

Hi, dates in Access are delimited by the # sign: #21.01.2009#

Hi Chris, why are you using

Form2.lstErrors.AddItem ""

twice?

Hi Chris, let's suppose the control name is "Customer", then

ctl.ControlSource = ctl.Name

sets the Customer control's ControlSource to "Customer"

but then...why not just set ControlSource via the control's property sheet?

but... for example... If qdf.Connect > "" Then it means the .Connect property already has a connection string so why substitute it with

...

Hi Bill, what does

.Connect > ""

test?

Have you tried the SQLConfigDataSource API? http://support.microsoft.com/kb/171146

Well done Chris!:-)

Could you post the excel file containing the code?

What do you mean "using Data tables"?

I see in your code

Dim drs() As DataRow = ds2.Tables(0).Select(expression)

What's DataRow? Even if I add a reference to Excel(11) Object Library I don't see...

Can you use the Case statement in Access?