Search results for query: *

Thanks for the replies! What I need is to step through the values and write to a access database so that it looks like this. Put the Entry Date on each post and then select only these values that are relevant. The file I am trying to import is much larger than this sample file and contains three...

Have this macro to read through the data, need to extend it a bit so it goes through the whole XMLfile and also outputs the data into an accessDB. Also would need the entry date to be put on each line instead of the null value. On the last row I'll provide a sample from the file, if you want to...

Need to loop through the values and put them in an access DB. Any ideas on how to proceed? XLS stylesheet or XMLDom? The xml structure looks like this: - <curve id="22186" title="Avg TT All ECM12 D1 FW" type="forecast"> - <entry date="2005-01-01 00:00:00"> <point date="2005-01-01...

Hello! I have a http:// link to an .asp page which outputs xml data that I need to import into an access database. Not very good at vba so any help is welcome. Need to open a connection to the web page, import the data in the document to the correct tables. I've tried downloading the xml file...

How can I get this PL/SQL Statement to run from an excel macro? And I also need to be able to change the &quot;from date&quot; and &quot;to date&quot; from cells in excel. It's a Oracle 8 database. -- select trade info (standard contracts) about trades that are in delivery during selected...

Thanks! Had a look at those threads but I still couldn't solve it. Don't know enough I guess :) The problem is it's an PL/SQL Statement I'm trying to run from excel and it won't execute properly in the macro. Any ideas?

Anyone able to help me out with this? Still haven't solved it and need it desperately by monday :( Thanks!

Putting in the entire SQL Query that I need to execute. Can't get it to work from excel and I need some help with how to set up so I can change those p.startdate p.enddate. Or if anyone has a bettre solution but with the same results I would appreciate it very much :) -- select trade info...

Thanks for the reply! But how do I do it practically? I have a full queary that runs fine against the database in SQL Navigator, now I need to get the output in excel with the added funtionality that I can change the from/to dates from two cells in excel. Not good at VB so if anyone has any...

Hi! Have an SQL query that I need to execute from excel and get the results in a sheet. I also need to be able to change the from/to date from cells in excel Looks like this: (p.startdate between to_date('01.10.2003','dd.mm.yyyy') and to_date('31.10.2003','dd.mm.yyyy') or p.enddate...

I checked and it's not in a date/time column, tried changing that but the format isn't accepted. How can I do as you suggest? The dates are in a text column. Will I get the arithmetic value for every month between the selected timeperiod when I get this query to work? If I choose from 01.2000 -...

Thanks for the reply! I could only get the sum(price*volume) / sum(volume) working without the month or week function, would like to get both of them to work but if it's as complicated as you say with the weeks then I can settle for the monthly function to start with. My dates look like I...

Hello. Not very good at sql so I need some help. Have a table with three different columns, all hourly values. Looks like this. Date Price Volume Sat 01.01.2000 00:00 110 1500 Sat 01.01.2000 01:00 210...

Hmm well I tried with all the passes I could think of and none worked.Seems like all the user account settings are unaccessible, I can't access the mapped drives from client computers either. What would happen if I reinstall exchange over the old installation ? Would that set the correct user...

np m8 :) Tried blank pass already, didn't work. Was there a special pass I used as the Directory Service restore password? Did the dcpromo a while back :/

Well the problem is I can't logon when I boot in Directory Restore mode :( My admin logon/pass doesn't work. Very strange.

Hi! Have a problem with a win2k server that is Domain Controller w. SP3 running Microsoft Exchange 2000. I had a small crash so I had to run the repair tool from the win2k cd. It seemed to work and the system booted but now I can't access the AD. Error message: &quot;Naming information cannot be...