Recent content by Loomah

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"...