ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to update Access Table with Excell Data (https://www.excelbanter.com/excel-programming/281587-how-update-access-table-excell-data.html)

Kevin Jones

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?

Phobos

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