SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

appending a MS Access table

Reply
Regular Contributor
Regular Contributor
Posts: 170

appending a MS Access table

Does anyone know how to append data from data set to an MS access table with same variables?
Thanks Lawrence
Super Contributor
Super Contributor
Posts: 3,174

Re: appending a MS Access table

Super Contributor
Posts: 291

Re: appending a MS Access table

Lawrence;

A method I have used is to proc import the original access dataset, append the new data inside of SAS and then proc export the new larger dataset as an over write of the old.

Bill
Ask a Question
Discussion stats
  • 2 replies
  • 264 views
  • 0 likes
  • 3 in conversation