pharmkittie (2/15/2016)

---

Thanks Phil, but where is the example? I do have a foreach loop that dynamically changes to connect in turn to each Access db's filename. The table...

There are a lot of resources and articles already written about this (here, for example).

Assuming that you are familiar with the tools available to you, can you be more specific...

An alternative approach is to loop round the tables, whatever they are called, using a foreach loop. Here is an example.

mw112009 (2/12/2016)

---

Reply to Post #1760966 from Lynn

The answer is "YES" ( I mean I am able to modify the code )

Why do I need the code ?

I have to copy...

Hugo Kornelis (2/12/2016)

---

Heh!...

Grumpy DBA (2/12/2016)

---

"Give a man a fish and he eats for a day. Teach a man how to fish and he eats for a lifetime."

I believe Brandie was trying...

It's helpful in that it proves that this is purely a...

scotdg (2/12/2016)

---

Thanks for the link.

My inexperience may show here with my questions/responses but in response to the options presented in that kb article:

I am not really sure how the proxy...

General Relativity, to be more precise :w00t:

In your debugging, were you able to detect whether the ExcelReader was retrieving any data?

Have there been any environment changes? Software updates? Permissions changes (including at network/file level)?

Provide the output you expect, based on the data you provided.

Not an English...

Your description is unclear. Are you able to introduce clarity by...

SQLAddict01 (2/11/2016)

---

I have a column with varchar data type but has numeric data in it

I know I can't use arithmetic operation for varchar

This is my query

select * from table1

where col1>...

yb751 (2/11/2016)

---

Just a couple things to consider. Make sure you validate your data to make sure it's actually a number. i.e. (ISNUMERIC). Secondly, try to avoid using CONVERT...