Re: Copying from one record set to another

INTP56 wrote:
Hi, I am trying to do a workaround while I'm trying to resolve an
issue with the SQL Server implementation that does the same thing,
but is currently broken.

Basically, I have an MDB file with two tables in it, and two tables
in SQL Server that look just like the tables in the access database

Both tables have an auto increment field on the Access side. I want to
select the new records from the Access db and insert them into the
SQL DB.

I can get to both DBs from Excel. I can write code that pulls the new
records from Access into Excel,

Excel???
Stop. You're killing me :-)
There are some simple solutions for this situation:
1. In Access, simply create links to the two sql server tables in your
Access mdb and run a couple insert queries.
2. In SQL Server: create a linked server in SQL Server pointing at the
Access database and do the same thing: run a couple insert queries to
copy the data.
3. In SQL Server: use DTS (SSIS if SQL2005) to import the data from
Access into SQL Server?

OK, OK, I know the answer is that you probably don't know anything about
these concepts. Well, now's the time to start reading:
read about linked tables in Access online help - a linked table can be
treated just like a local Access table in a query
or
linked servers in SQL Server BOL (online help)
or
DTS/SSIS in SQL Server BOL (online help)

If you need help with option 1, post to an Access newsgroup.
For help with the other two options, post to a sql server newsgroup


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • RE: First update to linked server fails
    ... this should be SQL server related issue. ... that you post this question into the SQL server newsgroup. ... you may want to contact Microsoft CSS directly. ... I am accessing a linked server through a VPN connection. ...
    (microsoft.public.windows.server.sbs)
  • Re: Put database on Internet
    ... I have read various posts about splitting database and using MSDE for the ... I have tried MSDE, ... Do I set up my desktop computer to serve as SQL server, ... When I created an ADP according to Access' online help, ...
    (microsoft.public.access.dataaccess.pages)
  • Re: inserting data in mdf table in asp.net2 using SQL server2005 express
    ... Have you looked a VB.NET 2005 Beta 2 online help? ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Copying from one record set to another
    ... I had a version using linked servers in SQL Server, ... I have another thread in the SQL server newsgroup looking for an answer ... read about linked tables in Access online help - a linked table can be ...
    (microsoft.public.data.ado)
  • Replication problem SQL server and Sql server CE
    ... I have set up an SQL server 2000 and a pocket pc2000 with SQL server ce 2.0 for merge replication. ... Somehow I cannot get replication working at all. ... Although the publication is defined as described in the online help I keep getting problems when executing the Synchronize method (missing data about publisher. ...
    (microsoft.public.sqlserver.replication)