From: G Schaller on 11 Jan 2007 15:46 Geoff. That isn't correct. You can have as many connections open at once as you like (subject to settings inside your RDBMS). Further, if you use MS SQL Server or Express you can easily query other DBMS (such as Oracle or DB2) and move and copy data accordingly. Geoff "Geoff Chambers" <gchambers02(a)msn.com> wrote in message news:1168529560.986322.52020(a)p59g2000hsd.googlegroups.com: > I don't see how this works, I can have only one connection at a time. > There are 2 databases the one in production and the one I modified. I > want to pull all of the data from one table in the production file and > add the data to the modified file. > > > Stephen Quinn wrote: > > > Geoff > > > > > >> > > > I have an application in production that is only using one module in the > > application. I have greatly modified the SQL database and would like to replace > > it with the one in use now. The problem I have is I need to extract all of the > > data from one table and add the data to the new table. I read were you can > > output a sleect command to a text file, but don't see anything on inseting in a > > table from this Text file. > > > > Is there a simple way of doing this? > > << > > > > INSERT INTO target SELECT * FROM source; > > > > HTH > > Steve
First
|
Prev
|
Pages: 1 2 3 4 Prev: Crystal Report "Basic syntax not supported" Next: Wildseek doesn't work with memo-fields |