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...
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 "from date" and "to date" from cells in excel. It's a Oracle 8 database.
-- select trade info (standard contracts) about trades that are in delivery during selected...
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...
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...
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: "Naming information cannot be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.