![]() |
How to update Access Table with Excell Data
I have a work book for data entry. It creates 1200
piecies of data. I have maped these data to a column in a seperate worksheet. I have been able to print data to delimited txt file. I would like to automaticly publish this data to a access table. Any suggestions? |
How to update Access Table with Excell Data
Set up a linked table in Access with your Excel doc as the source, then let
Access handle the data migration using SQL. P "Kevin Jones" wrote in message ... I have a work book for data entry. It creates 1200 piecies of data. I have maped these data to a column in a seperate worksheet. I have been able to print data to delimited txt file. I would like to automaticly publish this data to a access table. Any suggestions? |
All times are GMT +1. The time now is 09:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com