| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting data range from Excel to Access
I have an Excel template with a range called data_range. I want to create an
Excel macro that exports this range to a table called Data in an Access db called contract amendment log.mdb I'm stuck. I can work out how to import the data using Access but most of my users don't have Access so I want them to use Excel and export the data across our network. Each Excel file is created from a template so the name is not fixed. Can anyone help me? Thanks and regards, Shep |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Exporting data range from Excel to Access
Hi Shep
See this page http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl "Shep" wrote in message ... I have an Excel template with a range called data_range. I want to create an Excel macro that exports this range to a table called Data in an Access db called contract amendment log.mdb I'm stuck. I can work out how to import the data using Access but most of my users don't have Access so I want them to use Excel and export the data across our network. Each Excel file is created from a template so the name is not fixed. Can anyone help me? Thanks and regards, Shep |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Exporting data range from Excel to Access
That's perfect. Thanks so much Ron.
Shep "Ron de Bruin" wrote: Hi Shep See this page http://www.erlandsendata.no/english/...php?t=envbadac -- Regards Ron de Bruin http://www.rondebruin.nl "Shep" wrote in message ... I have an Excel template with a range called data_range. I want to create an Excel macro that exports this range to a table called Data in an Access db called contract amendment log.mdb I'm stuck. I can work out how to import the data using Access but most of my users don't have Access so I want them to use Excel and export the data across our network. Each Excel file is created from a template so the name is not fixed. Can anyone help me? Thanks and regards, Shep |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Exporting data range from Excel to Access
"Ron de Bruin" wrote:
See this page http://www.erlandsendata.no/english/...php?t=envbadac Ron, I have successfully used the code found at this page to upload info from Excel to Access. However my needs are a bit more advanced. I need a method to control the upload - either to make the upload only happen once when pressed, or else to find the data in access and overwrite it. Currently when you press the button multiple times, the information is continually appended. I'm developing a timesheet system and want employees to upload time to the database one a month, and I need an internal control for that. I may even need the ability for them to edit the data. Can anyone help with this request? It seems to be an advanced request, and I am new to using Visual Basic. -- Regards Ron de Bruin http://www.rondebruin.nl "Shep" wrote in message ... I have an Excel template with a range called data_range. I want to create an Excel macro that exports this range to a table called Data in an Access db called contract amendment log.mdb I'm stuck. I can work out how to import the data using Access but most of my users don't have Access so I want them to use Excel and export the data across our network. Each Excel file is created from a template so the name is not fixed. Can anyone help me? Thanks and regards, Shep |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exporting data from access to excel | Excel Discussion (Misc queries) | |||
| Exporting data from access to excel | Excel Worksheet Functions | |||
| Exporting data in Excel permanently to Access | Links and Linking in Excel | |||
| Need Excel macro for exporting data to Access | Excel Programming | |||
| Exporting Data from Excel to Access Problems | Excel Programming | |||
Linear Mode
