Viewing 15 posts - 1 through 15 (of 16 total)
I don't understand Noel's suggestion. My situation is that I get files (6) from different Gov agencies--OFAC, GSA, DPW, HAP, HAP Nursing, etc... I have absolutely no control over the...
April 26, 2005 at 2:57 pm
Unfortunately, I get the Regulatory table from government sources. So, I am at their mercy in terms of what information I am provided. They only provide the name and address--no...
April 26, 2005 at 2:15 pm
I run the sql statement through the DTS package--It is the "Execute SQL Task" icon within DTS.
April 19, 2005 at 1:32 pm
The parsing worked great. I was able to complete about 6 files. I have another question with regard to the Active X script and parsing, though. I have a single...
April 4, 2005 at 8:26 am
Thank you for the solutions. I used the Active X script suggested by David--added that to the script that was already running--it works great. I have one more question with...
March 24, 2005 at 5:44 am
I made another stab at the Active X transformation and did the following. First, I used sql to remove all of the Jr., Sr. I, II, III, medical degrees, etc......
March 23, 2005 at 6:12 am
Thank you for the examples. I would like to use the one offered by David, however, I am not a programmer and the code doesn't seem to work. Is there...
March 14, 2005 at 1:44 pm
Here are some examples
City,State (just a comma no spaces)
Pittsburgh,PA
Whole Name (Unfortunately this combination is all within one spreadsheet--whole middle name mixed with initial)
Struthers, Sally J.
Barker, Bob P.
Carmike, James Anthony
Whole Name...
February 25, 2005 at 6:31 am
Thanks noeld. That works perfectly. Such a simple solution to a problem that has consumed quite a bit of my time.
February 23, 2005 at 1:25 pm
For my purposes, the address doesn't really matter--some of the data that will come in will have no address at all or addresses will be spelled differently or will be...
February 23, 2005 at 1:14 pm
I made the changes to the sql server table (on the server), then recreated and/or refreshed the links (tried both several times). However, this causes the following problem: When a...
September 15, 2004 at 7:51 am
Your assumption is correct. However, new data can be added via the access interfaces (forms or through the table view), but no data that was present can be edited. It gives...
September 14, 2004 at 2:39 pm
Your assumptions are correct; however, I don't see where you are going with this. Are you asking whether primary and foreign keys are set for all tables. If so, then...
September 14, 2004 at 12:30 pm
Thank you for the suggestion, however, 2 things:
One, I tried to make the change in the linked table through access. It won't save any changes as it tells you that...
September 14, 2004 at 11:47 am
We do the same thing routinely. The issue I have is the restoration of msdb and the fact that the dbid's were not the same on the new box vs....
July 16, 2004 at 11:32 am
Viewing 15 posts - 1 through 15 (of 16 total)