Viewing 15 posts - 52,921 through 52,935 (of 59,068 total)
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...
January 14, 2008 at 5:27 am
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...
January 14, 2008 at 5:12 am
I guess I don't understand... why does the addition of columns to tables in ACCESS have to be automated to begin with?
January 14, 2008 at 5:10 am
If we had found a solution for you, everyone would benefit because we would post the answer. To be courteous, you should too...
January 13, 2008 at 8:08 pm
You must create a scheduled job that logs into the FTP site and checks to see if the file exists usining FTP directory commands.
January 13, 2008 at 8:07 pm
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.
January 13, 2008 at 8:04 pm
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...
January 13, 2008 at 7:58 pm
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.
January 13, 2008 at 7:53 pm
I have a stored procedure that has suddenly started taking longer to execute.
Before you do anything, you must determine exactly what changed... and, trust me, something changed. Things...
January 13, 2008 at 8:39 am
icata (1/11/2008)
From what I found so far...
January 13, 2008 at 8:30 am
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...
January 13, 2008 at 8:25 am
The user that the SQL Service logs in as, must have permission to "see" the share.
January 13, 2008 at 8:15 am
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...
January 13, 2008 at 8:13 am
Ghanta Bro (3/27/2006)
someone!
And, this is a forum... not online help... don't be so rudely impatient, please.
January 13, 2008 at 7:57 am
Ghanta Bro (3/28/2006)
January 13, 2008 at 7:56 am
Viewing 15 posts - 52,921 through 52,935 (of 59,068 total)