| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to Access
Can I write a macro that will export one row of data (A2:X2) to a table in
Access automatically? If so, can I do that with multiple spreadsheets of the same ilk going to the same table in Access? I have the summary page in Excel laid out in a database type of style for ease in conversion to Access. I originally tried using "Paste Link" from the summary page of the estimating spreadsheet we use to a master summary page of all jobs and then linking that page to Access. This is a little flimsy and unreliable with non-computer friendly people using it. I need something idiot proof that will work on its own. I would appreciate any help you could give me, Excel Gods. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel to Access
There is nothing truely simple here... You can write to an Access database
via an ODBC connection which is not that terribly diffictult to do. The trick is in making it automatic and ensuring that you do not post the same info multiple times. Depending on your database you may also need to worry about referential integrity. In any case if you are looking for the magic button to push there isn't one. If you are not scared off by talk of ADODB recordsets and such then post back and we can point you at some resources to get you started... -- HTH... Jim Thomlinson "dmac" wrote: Can I write a macro that will export one row of data (A2:X2) to a table in Access automatically? If so, can I do that with multiple spreadsheets of the same ilk going to the same table in Access? I have the summary page in Excel laid out in a database type of style for ease in conversion to Access. I originally tried using "Paste Link" from the summary page of the estimating spreadsheet we use to a master summary page of all jobs and then linking that page to Access. This is a little flimsy and unreliable with non-computer friendly people using it. I need something idiot proof that will work on its own. I would appreciate any help you could give me, Excel Gods. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel to Access
I've got about a month to figure this out so point away. I'm not sure what
you mean when you talk about ODBC connection and ADODB recordsets, but I'll learn. Thanks "Jim Thomlinson" wrote: There is nothing truely simple here... You can write to an Access database via an ODBC connection which is not that terribly diffictult to do. The trick is in making it automatic and ensuring that you do not post the same info multiple times. Depending on your database you may also need to worry about referential integrity. In any case if you are looking for the magic button to push there isn't one. If you are not scared off by talk of ADODB recordsets and such then post back and we can point you at some resources to get you started... -- HTH... Jim Thomlinson "dmac" wrote: Can I write a macro that will export one row of data (A2:X2) to a table in Access automatically? If so, can I do that with multiple spreadsheets of the same ilk going to the same table in Access? I have the summary page in Excel laid out in a database type of style for ease in conversion to Access. I originally tried using "Paste Link" from the summary page of the estimating spreadsheet we use to a master summary page of all jobs and then linking that page to Access. This is a little flimsy and unreliable with non-computer friendly people using it. I need something idiot proof that will work on its own. I would appreciate any help you could give me, Excel Gods. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel to Access
This is worth a look:
http://www.exceltip.com/st/Export_da...Excel/425.html This is good too: http://www.programmingmsaccess.com/T...20Overview.htm Regards, Ryan-- -- RyGuy "dmac" wrote: I've got about a month to figure this out so point away. I'm not sure what you mean when you talk about ODBC connection and ADODB recordsets, but I'll learn. Thanks "Jim Thomlinson" wrote: There is nothing truely simple here... You can write to an Access database via an ODBC connection which is not that terribly diffictult to do. The trick is in making it automatic and ensuring that you do not post the same info multiple times. Depending on your database you may also need to worry about referential integrity. In any case if you are looking for the magic button to push there isn't one. If you are not scared off by talk of ADODB recordsets and such then post back and we can point you at some resources to get you started... -- HTH... Jim Thomlinson "dmac" wrote: Can I write a macro that will export one row of data (A2:X2) to a table in Access automatically? If so, can I do that with multiple spreadsheets of the same ilk going to the same table in Access? I have the summary page in Excel laid out in a database type of style for ease in conversion to Access. I originally tried using "Paste Link" from the summary page of the estimating spreadsheet we use to a master summary page of all jobs and then linking that page to Access. This is a little flimsy and unreliable with non-computer friendly people using it. I need something idiot proof that will work on its own. I would appreciate any help you could give me, Excel Gods. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trust Access to Visual Basic Project - Access to Excel and back | Excel Programming | |||
| How do I access the access data via Excel 2002 with auto update ? | Excel Programming | |||
| Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Getting Access Error Messages when running Access through Excel | Excel Programming | |||
Hybrid Mode
