Search results for query: *

Any chance XP Access has this functionality? Thanks for your help. mlong [afro]

I would like to perform an insert based on a select statement. The catch here is that I would like to insert the records using a pass-through query, where the select is based on a table from the Access database. For example, a pass through query like this... insert into OracleDB.table1(cola)...

That worked! Thank you for your quick response. Thank you, Mike

Hello all. I would like to insert data from an Access 97 table/query into an existing Oracle 8 table. I realize that a link table query should work, and I have proven that it does in my environment. However, because I am linking to Siebel tables, some of the links fail, as the Siebel tables...

I normally call an .exe file from the command prompt or using a .bat file, and pass it parameters. I would like to automate this using a vb program. I have tried the shell visual basic function, but it doesn't seem to handle parameters. I also tried to use the SendKeys function with the...

I am trying to use the db2cmd utility to spool my result set to a flat file. I have no problem getting the data into the flat file, however, it always contains some db2 header and footer information. Does anyone know how to remove this from the output file, either using a db2cmd option or...

Db2 version 6.1 I have a job which is using the db2cmd utility to import data from a flat file into a db2 table. One of the columns, a varchar(1500), is being truncated at 35 characters when it is imported. Additionally, I noticed that our db2 software package defaults to a max column...

It worked!!!! Thank you so much Terry!!!!!!!!!!!!!!!!!!!!! --Mike Long

Using SQL Server 7 (very soon 2000)! I have two tables (a & b) that have the same key (a.key, b.key) and a few of the same fields (a.checksum, b.checksum). I'm trying to compare the records in these tables, and wherever the same keys do not have matching checksum fields, then I would like to...