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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Table Update
Hi, I'm an Oracle novice so any help is appreciated. I have 2 tables with fields shown below: MASTER TEMP PartNumber PartNumber MaxStock MaxStock other fields calculation fields TEMP contains a subset of parts from MASTER and I want to update the MaxStock in MASTER with the...- Andy7777
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
Using CAST to return Integer from SmallDateTime
Hi, I need to convert dates in SmallDateTime format into Intergers. When I use CAST on '25/07/2003 11.26', SQL Server returns 37825. However, Excel spreadsheet returns 37827 when I format the date. CAST through SQL Server is exactly 2 less than Excel (even when using floating point...- Andy7777
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Error using ADO to Update Excel Spreadsheet
Hi, I am using VB6 to manipulate data in an Excel Spreadsheet. If the Spreadsheet is open in Excel then I can open a Schema to view the fields (column names) OK, but if I try to create a new table (shown as a worksheet) using SQL then I get dumped out of VB with a "..tried to access...- Andy7777
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
SQL-CREATE TABLE> list of datatypes for dBase, Paradox, Sql Server
Hi, I have writen a VB app (uses ADO 2.6) that connects to various databases and spreadsheets and creates tables within them. It currently works with Access, Excel and SQL Server but I also need to connect to dBase, Paradox, Lotus123, Oracle and text files. Depending on the...- Andy7777
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
