"Insert Into" SQL Server 6.5 from Access 97 using VB5?
Why don't you create a link to the SQL data table in Access? Then you can
make a connection to the Access database, and do "INSERT SQLCorres SELECT *
FROM AccessCorres"
Is it necessary to do this procedure more than once or are you merely
upgrading?
tu
Quote:
>If I run the SQL against a ODBC connection, will something like the
>following be the way to go?,
> Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "sa", "sa", dbUseODBC)
> Set conCIMS = wrkODBC.OpenConnection("Connection1", dbDriverPrompt)
> s_SQL = "INSERT INTO SQLCORRES "
> s_SQL = s_SQL & " Select AccessCORRES.* From AccessCORRES IN [MS Access
>database]"
> conCIMS.Execute
>Any suggestions on the best way to append multiple records from a table in
>an Access database to one in a SQL Server database? Even URLs for VB FAQs
>would be appreciated. I've checked about a dozen VB sites and have not seen
>this item covered. I hope it is feasible.
