Search results for query: *

Frederico Many thanks for all your help! I still can't get to the bottom of the mystery of why there isn't a newer version of the Delimited File Reader out there in the wild but hey-ho! Instead I have been loking at an alternative (which I wish I'd thought of 3 years ago!) What I am trying is...

Frederico I haven't been ignoring your help, I just don't have the time to look properly at the moment. My role, as previously mentioned, is to answer the question can this be migrated form 2008 to 2012/2014 with minimal effort. The current answer is no but I want to get an answer as, when the...

Frederico Thanks for the response, changing the source code seems a great idea. Unfortunately I wouldn't know where to begin!! I'm not actually a developer and my knowledge of SSIS/SSDT is limited. I've looked at the code on CodePlex and fall at the first hurdle - the only language I actually...

Hi 2 or 3 years ago I created my first SSIS package in SQL2008, upgrading SQL2000 DTS packages. I knew little of ETL at the time (I'm not much better now!) When I was doing this everything fell at the first hurdle - ie importing some data from a csv file. There were numerous errors and when...

just a quick addition to this - you can also set calculation to use 1904 date system in xl's options ;-) If a man says something and there are no women there to hear him, is he still wrong? [ponder] How do I get the best answers?

combo as it stands excel is the must have feature but i'm at the stage of wondering if that's because "we've always done it that way" - the supply of this data dump predates my arrival in this organisation, some 4 years ago, by quite a time. i'm planning to meet with the customer to re-assess...

combo thanks for that and sorry i didn't pick up on what you were telling me the first time! however (and i may just be having a 'senior' moment here) i'm not entirely sure how your suggested solution/alternative helps. i would still, surely, be in the situation where i need to dump 420k...

combo access isn't an option as the end user doesn't have it on their systems and there are issues surrounding accessing anything held by "me" across different domains. the requirement is for a full data dump from a system with a second dataset merged with it. the background is messy and...

hi i'm trying to use the code below to copy data from a sql (2008 r2) table to multiple sheets in excel 2003 - there are currently c420000 records, expanding at around 1000 a week. this is the requirement, i have no option to use access or later versions of excel for the output. i have been...

or =sumproduct(($g$1:$g$50000=a1)*($h$1:$h$50000="core")) where a1 contains the year ;-) If a man says something and there are no women there to hear him, is he still wrong? [ponder] How do I get the best answers?

ha ha ha - that has to be the most randomly misplaced thread i have ever seen in these forums (or any others)! almost tempted to give it a star for all the wrong reasons but for brightening my day! hi geoff, hows it going? ;-) If a man says something and there are no women there to hear him...

hi and thanks for the input. thought i would share this though as i'd not come across it before. i was looking for a way to transfer outlook account settings (logons etc) and discovered this which also fixed my xl settings! Start>All Programs>Microsoft Office>Microsoft Office Tools select...

hi i think i'm going mad! i've just set up a new home pc with windows7 pro (64bit) having loaded office 2003 i then copied my 'old' excel11.xlb file over to the new machine. when i open it it retains the customisation i'm used to but after closing it and opening excel from the programs menu it...

ok, note to self "check what has happened in a thread while you've been messing around before posting and you might not end up looking like you're asking stupid questions of the original poster" noted!! ;-) If a man says something and there are no women there to hear him, is he still wrong...

not really sure what you are trying to do the following will list each of your values in each empty cell - ie all 6 codes in one cell. Sub Jugated() Dim strIpped As String strIpped = "55400" & Chr(10) & "55401" & Chr(10) & "55402" & Chr(10) & "55403" & Chr(10) & "55404" & Chr(10) & "55405"...

hi in addition to what combo has said i woke up this morning thinking what i said earlier was complete wotsits! the issue is with one event firing the other. disabling events doesn't affect in this case (no idea why?). the bigger issue i wasn't thinking about yesterday is that toggelbuttons...

hi what happens if you remove lines 7 & 16? or what happens if you insert the line application.enableevents=false before lines 7 & 16 then set back to =true after 7 & 16? i don't understand why this works on 1 pc and not the other though! ;-) If a man says something and there are no women...

hi what you've used works fine for me but without the curly brackets "{}". not sure why you have them in there? ;-) If a man says something and there are no women there to hear him, is he still wrong? [ponder] How do I get the best answers?

PH - thanks again! Andy I get what you're saying. However the data comes from a 'live' system via a download and already has access bursting at the seems! adding another 5 fields for the sake of 1 report from a dataset that should be transfered to sql server (and will be at some point) isn't...

phv was just about to post back - that was the other idea i had in my last post!!! have just tried it and it is looking good but still have to test the results from it more thoroughly! thanks for the input, as always ;-) If a man says something and there are no women there to hear him, is he...