Search results for query: *

I think you should change your perspective a little... Demand IT: From a business perspective (ie your perspective). You should be thinking how much will this cost the company in overall change? Ie Staff training, Software support, integaration with other systems , cost reduction, increase in...

Dude, I take back what i said before. I think the best way is to write a store procedure that will calculate the IRR in SQL Server. I come from a finance background and the formula is fairly simple. It may be a little tricky calculating in a database but it will not be difficult. Just make the...

Yes. 1. VB front end application that uses the Excel library. 2. Access,Excel VBA macro. 3. C external stored procedure. I think there is a 80% chance that you will have a front end application of some kind. In the front end before you show the IRR calculate it. Without a front end. I would...

Depends on your front end? I have a similar problem with Japanese characters. test it out using the latest downloads of the SQL ODBC driver MS Jet Engine 4.0 and MDAC drivers. Also make sure the machine that you enter the data in on is the machine you view the data. 1. ODBC driver version...

HiBoo, I write lines to a batch file and then execute the batch file with the VBA fundction that executes NT command's ShellCommand(Command, Visible or not) 1. I function that gets all of the excel spreadsheets file names in a directory 2. For each file name I change it to a standard file name...

Try: select * into database2.dbo.table2 from database1.dbo.table1 Creates a new table in database2. You'll have to move the indexs across another way. Between servers: Use Open rowset. Select * into Db2.dbo.NewTable FROM OPENROWSET('SQLOLEDB','TESTSRV2';'DFB';'DFB', 'SELECT * FROM...

Help.Maybe. I have a similar problem. If the data inside the database (eg tables etc) is the same 1. create one DTS package that imports an .mdb (like webimport.mdb), 2. then change the name of the .mdb from WebDB1.mdb to webimport.mdb, WebDB2.mdb to webimport.mdb, etc... This can be done...

Yes. See code tips and techniques from: www.sqldts.com Be the change that you want to see in the world - Mahatma Gandhi

I suspect the person has created the DTS package with "NT User Authentication". You'll see what I mean when you try and save the package. It will ask you for a package name and User id password. Be the change that you want to see in the world - Mahatma Gandhi

The structure of the table I am importing from Access and Excel should always be the same yet the name changes for each month. So... 1. Use xp_cmdshell to change the name of the file I am importing. So that the DTS package recognises it. eg from JuneData.xls to Data.xls 2. execute the DTS...

Thanks guys. I appreciate the joke foxdev and the link. : - ) Be the change that you want to see in the world - Mahatma Gandhi

Thanks guys. I appreciate the joke foxdev : - ) Be the change that you want to see in the world - Mahatma Gandhi

rubansilvester, Personally I like OPENROWSET. But Terry Broadbent has convinced me that DTS is a handy and powerful tool. Now I use it with dtsrun console app. that rename's the input file to the name that the pre-compiled DTS package expects. Import with dtsrun. then rename the file to its...

Some good tips for forum participation. I will keep them in mind going forward. (one tip was to let the person answering the question know that there suggestion was helpful) I hope this is the expected rebutle. Be the change that you want to see in the world - Mahatma Gandhi

1. Check that you have indexed and set a primary key on your SQL table. Other than that I'm not sure. I did read information on data type conversions that ODBC does between SQL Server and Access in the BOL.

There is some documentation on the Oracle Tec net website. www.oracle.com I think that Oracle has a lot less gui but it has very good free documentation and has some powerful features that SQL doesn't seem to have. The reason is Microsoft sells its front apps or data access to Excel what ever...

This may sound a little overkill but its the only thing I could think of... 1.. Retrive the user id of the person logged in. (there is VBA code for this somewhere I'm not sure...) 2. Have the user id in a table that shows what department that person is in. 3. Update the table whenever there...

Sorry to evade answering your question but... Why would you use C++ to import a text file into Access anyway? It is very easy to do this in Access and I can't see any gain from using C++ (Automation?). Also, Access as a database is very "resource consuming" on the workstation...

Hi I am trying to search for Data within a text file that uses , to denote a column and there is a carriage return at the end of each line. I need to check the validity of about 12 items in a text file. I can find some elements in the text file using searchchr however I can't use the CString...

Not sure but try:<br>SendKeys &quot;{F9}&quot;, True<br>HTH