Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Append records from Access table to Sql Server table

I am trying to create an Append query in Access to append all of the records in my access table to a Sql Server table. I have the Sql Server table linked to the Access database.  Your help is appreciated.

Thanks,
Brooks
0
gbnorton
Asked:
gbnorton
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I have the Sql Server table linked to the Access database.
>append all of the records in my access table to a Sql Server table.

Should be a sinple as creating an insert table, select your local Access table, click on the Append button and select the linked SQL Server table, then one-by-one click on the columns and make sure they are mapped correctly in the 'Append To...' row.   Then execute.

The SQL will go something like this

INSERT INTO LinkedSQLTable (Column1, Column2, Column3, ColumnN) 
SELECT Column1, Column2, Column3, ColumnN
FROM LocalAccess table. 

Open in new window

0
 
gbnortonAuthor Commented:
Thanks Jim.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now