Adrian is correct,

Anything that looks like a numeric entry, will be treated like one by Excel. If you type 000123 into Excel, it will be changed to 123 by...

One might also try posting the original question on an Access forum... I do very little in Access and don't know the answer other than running the script you originally...

I guess I don't understand... why does the addition of columns to tables in ACCESS have to be automated to begin with?

If we had found a solution for you, everyone would benefit because we would post the answer. To be courteous, you should too...

You must create a scheduled job that logs into the FTP site and checks to see if the file exists usining FTP directory commands.

You cannot output columns that are not in the GROUP BY unless they are in an aggregate function... read Books Online for the proper use of GROUP BY.

I strongly suspect that the only mod that has been done is the number of rows have increased. 2.5 million rows is right at the threshold of the "tipping...

No... they are not necessary. When the format of the file changes, then you know there is a change. Headers are not necessary in fixed format.

Before you do anything, you must determine exactly what changed... and, trust me, something changed. Things...

icata (1/11/2008)

---

Thanks, I am working to implement a software package that creates a database per client, with a target of more then 1500 clients.

From what I found so far...

Heh... everyone forgets a couple of the most important tools you could ever have in you DBA toolbelt...

A full up copy of MS Office Pro so that you can test...

The user that the SQL Service logs in as, must have permission to "see" the share.

I think the big problem here is that, like the old "GWBasic" and "BasicA", VBS is "interpretive" rather than compiled code... makes it pretty slow and that's another reason why...

And, this is a forum... not online help... don't be so rudely impatient, please.

Ghanta Bro (3/28/2006)

---

I guess the best way is creating a template, formatting the column with leading zeros as text and then using the template. But then I have to do...