Recent content by MattRichardsUK

Im sorry. now Im really lost is how should I read them into an array and rename

Hi I have a problem where i have a folder with number of system generated .txt files that it names 00001.txt, 00002.txt etc currently on 05473.txt. Each file has the descriptor for the file content as the first 10 characters of the firstline of said file. I am trying to use SSIS to loop...

Thanks for your replies, when i am back in the office in the morning. I will try them out and feedback.

It is an Old syem that has become critical to the business and any major change to data structure has to be sanctioned the above method is the only way the data will be allowed to be stored as making the change will to the structure will take too much time to obtain the signatures.

Hi I'm either trying to over think this as I think it should be quite simple. I have 2 tables The first with an Action Table which is a list of records and date for each eg.(RecordNumber, PDate). The second table is a history table with the list of records and 6 date columns eg.(RecordNumber...

Thanks for the help yesterday, sadly I am on contract at a company that only have the following options available to them via the 'sql server 7.0' program menu: Books Online Client network Utility Enterprise Manager * Import and Export Data MSDTC Administrative Console Profiler Query Analyzer...

Thanks for your speedy reply. I was a liitle trigger happy when it came to the 2005 its actualy sql server 7. I cant find an object explorer in this one.

I am trying to get the entire DDL for my existing SQL Server 2005 database extracted into a .sql file is this possible? and if so is there a set SQL code to accomplish this? Thanks M

I do not get that option when setting up the connection. Do you mean when setting up the connection in the ODBC Aministrator or is this an option native to excel

I have an Excel sheet that has 85 tabs of data that I would like updating from an oracle database. I have set up database queries on each and tested them all and they all run correctly. My problem is once I have closed and come back to the workbook at a later date, when i refresh data I get the...

yes there will always be a title and an initial. yes i think that is what i am looking for.

I have a table that stores customer information, at present I do not store the customer title, initials and forenames as separate fields - they are stored as a single field, for example, “Mr”, “Mr & Mrs”, “Mr J” and “Mrs AD” are stored as a single field. I would like to split out this field into...

Thanks very much, thats exactly what i was after

Hi, i have completed a report in Access97 and the users have asked for the detail section of the report to be striped row by row alternating from a light grey to white. I have drawn a blank on how to acheive this. I know it is possible but just cant remember how. Any help would be greatly...

Hi, I have a problem accessing reports from the OnDemand Server. I can log into the website no problem, and browse through the folders containing all the documents we have on the ODS. However, when I try to access a document I get two messages: Brio Quickview - File Error Error Opening File -...