Re: load data from Access to SQL

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 12:43:03 -0500

On Mon, 30 Aug 2004 16:18:38 -0700, "Andre" <no@spam.com> wrote:

¤ I'm writing a VB6 app to load data from Access97 to SQL2k. I've
¤ successfully written code to connect to both datasources but am unsure on
¤ how to proceed from here. What's the best way to load an Access table to
¤ SQL? Do I get the Access data into a rs then load it to sql? If so, how?
¤ :)
¤
¤ Any examples would be greatly appreciated.

The easiest method would be to create an Access linked table to the SQL Server database table and
then just use a SQL SELECT * INTO statement.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: Sql ce server process
    ... We are certainly aware of the dll load issue, ... application that is using sqlmobile and is on the virge of disaster. ... running 2 processes at the same time, one that uses the SQL Mobile engine ... unmanaged SQL Compact DLLs is that you need to get them loaded early in the ...
    (microsoft.public.sqlserver.ce)
  • Re: Sql ce server process
    ... We are unlikely to target another platform until WM7 ... My plan is not to try to use sql in any more robust of a fassion than was ... load on the database that is any more heavy than the load that exists today, ...
    (microsoft.public.sqlserver.ce)
  • Re: load access table to sql
    ... I'm able to load the table now using very similar code. ... having is because of a column named "Group" in both the local and sql table. ... >> Dim rst As Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Create index, create table statements are locking each other
    ... with same partition logic without indexes first, ... sql 2008 enterprise. ... SSIS packages do asynchronous data loads and after ... the data load create indexes for the finished data loads to speed up the ...
    (microsoft.public.sqlserver.programming)
  • Re: Specific LIKE statement
    ... But I need to load all records where field Name is one of the names in this string: "John is director, Jack is programmer, Jim is Analyst, James is manager". ... How to do that with SQL? ...
    (microsoft.public.dotnet.framework.aspnet)
Loading