ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Export Single Record to Append to Access Table (https://www.excelbanter.com/excel-discussion-misc-queries/213000-export-single-record-append-access-table.html)

RMS

Export Single Record to Append to Access Table
 
I have an Excell spreedsheet that does many wonderful calculations for
patient medications which change frequently. I would like to export the
single record result of those calucalations to append to an access table.
Then I would like to manipulate the data in the access table using access.

Thanks, any help appreciated.

Bob I

Export Single Record to Append to Access Table
 
You can Import the data from Access, or you can Save As CSV and then
Import it into Access. Either way you will do it from the Access end.

RMS wrote:
I have an Excell spreedsheet that does many wonderful calculations for
patient medications which change frequently. I would like to export the
single record result of those calucalations to append to an access table.
Then I would like to manipulate the data in the access table using access.

Thanks, any help appreciated.




All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com