Viewing 15 posts - 31 through 45 (of 112 total)
I like to use MS Access to do things like this (if it's available). Access can "link" tables to a SQL source as well as the source Excel sheet. Then...
January 31, 2012 at 3:02 pm
I have not run into this myself, but... since things work on the 32 bit machine, is it possible you could import into 32 bit as a staging DB then...
January 5, 2012 at 11:17 am
my point was that, sure, there COULD be a buisness need, but it's really a formatting issue and should be done at display time rather than stored. :hehe:
January 3, 2012 at 10:50 am
I missed all the ranting, but thought I might try to add something useful. During the thread someone brought up not seeing a business need for this. The one...
January 3, 2012 at 10:25 am
oh, booo! Rudolph was a scab brought in for an exception - not part of the team! 😛
December 27, 2011 at 2:59 pm
I've run into this a couple of times. Yes, it's our data, but not our database structure. I've been presented with massive data dumps but no table structures or...
December 21, 2011 at 2:51 pm
do you trust the person that maintains the MS Access table? If so, you might consider dropping the table from Access and just making a linked table from Access...
December 21, 2011 at 12:36 pm
WHAT?!?!?? you mean that people run the code then take credit for the answer? I guess I don't have to feel guilty when I google the QOTD any...
December 13, 2011 at 2:16 pm
don't know sqlite... it would be helpful if you describe what the function does and give an example.
October 13, 2011 at 2:31 pm
Sean - yeah, my company is going through some growing pains getting rid of some end user developed Access DB's. (We are actually a large agency that is the result...
October 13, 2011 at 9:41 am
SSRS is only equivalent to Access reports - and from what I've done so far, it's kind of clunky but that's probably my lack of experiance.
SQL Server has no equivalent...
October 13, 2011 at 9:22 am
OK... gotta add my 2 cents.
To the Original poster - someone else has already mentioned calling the stored proc using dao/ado in Access. The sp you post...
October 13, 2011 at 9:15 am
yep, that's what I was afraid of... expensive lesson learned.
thanks
September 28, 2011 at 10:07 am
not to be snarky, but if you Google just a little bit you will find literally 1,000's of posts, blogs, articles on the subject. Just read a few and see...
August 31, 2011 at 9:33 am
sorry about a non-answer, but I've just never seen another site as active and well-done as SSC for ANY topic.
August 29, 2011 at 2:30 pm
Viewing 15 posts - 31 through 45 (of 112 total)