Search results for query: *

Here's how I did it. This puts the XML into a record set. Function Main() Dim strConnect strConnect = "Provider=MSPersist" Dim rs SET rs = CreateObject ("ADODB.Recordset") Set SQLcn = CreateObject("ADODB.Connection") SQLcn.ConnectionString = "Driver={SQL Server}; Server= [Server Name]...

I too am having problems using OPENXML with a XML file. By replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help the both of us.

I too am having problems using OPENXML with a XML file. Perhaps by replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help us.

I too am having problems using OPENXML. Perhaps by replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help the both of us.

I realize what I am going to say will not make a lot of sense why I want to do this, but after I gave you long explanation, it would. I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the...

I realize what I am going to say will not make a lot of sense why I want to do this, but after I gave you long explanation, it would. I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the...

You are correct, field one is the name of the table to import, field two is the table to import into. Yes, the source and destinations have the same structure. IF I could SQL query the source tables, I’d be very happy. However, SQL Server cannot link the tables and its DTS Wizard does not...

This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...

This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...

This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...

I'm slowly getting it on my own. The part of the code that is giving me grief right now is, With rst .Source="bxj_Import" .ActiveConnection=oCn .CursorType=adOpenKeyset .Open .Find strCriteria Do While Not .EOF ... Specifically the line ".CursorType=adOpenKeyset". Since I want to use .find...

One of my co-workers gave me a hand writing the script. We think we’re on the right track and may even have it, but are receiving an error that we cannot figure out. The code we wrote is, Function Main() Dim sServer Dim sLogin Dim sPwd Dim oCn Dim rst Dim sNames Dim oFso Dim oFileOut...

:-) It’s not quite that easy (I tried that first). MS Access is able to do something SQL Server can’t, and that’s why I was using it. The database that the adp file is attached to is SQL server, not an Access database. So I’m essentially working with the SQL server with Access as the front...

I have a piece of code that is associated to a button on a simple form in Access. When I press it, it looks at a table for which tables to import from an AllBase database and then imports it/them. DTS’s Import Function does not work in this application because it doesn’t work with the ODBC...

I don't want this thread ending with me asking a stupid question. Right after I submitted it I realized how evident the answer was.

I kind of stepped away from this problem for a little while, now I’m back. PH, where exactly should I place that piece of code?

I apologize if this has been addressed in another thread, I didn’t see one that does. It’s kind of an age-old problem and was kind of surprised not to see a thread on it…designing a report to print in black and white/grey scale. I have a line chart that has six elements on it. The report will...

I had success last night, or at least I accomplished my goal. I more or less catered to the chart in my query by adding SELECT what.*, CASE WHEN what.ClassLL = 'Other BP' THEN what.Expn1 END AS Systolic, CASE WHEN what.ClassLL = 'Other BP' THEN what.expn2 END AS Dyastolic...

I posted this question in another forum (http://www.manning-sandbox.com/forum.jspa?forumID=97&start=0) and got the following response http://www.manning-sandbox.com/thread.jspa?messageID=42780&#42780. I have not been able to successfully implement his idea yet, but I thought you might...

Yea, I think it’s time for more clarification. Yes, all of the vitals are on one chart (as requested by one of the VPs). It doesn’t make sense to me either, but it’s what he wants. It is at the top of a daily report that shows a patent’s history for a one-day period. There is an Input/Output...