| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing data from excell to access. | Excel Discussion (Misc queries) | |||
| Transfering data/table from excell to access | Excel Discussion (Misc queries) | |||
| how can excell extract data from Access (hot line?) | Excel Worksheet Functions | |||
| insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
| How can I update an MS Access table record from within Execl works | Excel Discussion (Misc queries) | |||
Linear Mode
