Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Gumster
  • Content: Threads
  • Order by date
  1. Gumster

    Need help reading XML Document and writing to DB

    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...
  2. Gumster

    Need to import and XML document from the web to an Access database

    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...
  3. Gumster

    PL/SQL from excel

    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...
  4. Gumster

    SQL Query Oracle w dynamic dates

    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...
  5. Gumster

    Arithmetic value in sql query.

    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...
  6. Gumster

    Can't access Active Directory!

    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...

Part and Inventory Search

Back
Top