Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you Export Excel data permanently to Access
How do I export a range of data which is in a row/column format (i.e.,
row=record, column=field) in Sheet3 to a file that can then be easily imported to an Access table? Please point me in the right direction on the best way to do this. Thanks I am using Excel 2000 & Access 2000 FURTHER DESCRIPTION OF MY CURRENT SITUATION: I have an Excel file that my field techs enter data and print customer reports from. The file contains multiple sheets. Sheet1 is the data entry form. Sheet2 is the report then print which uses the data in Sheet1. Then, before the next job, I have a routine that the techs invoke that clears the input sheet (Sheet1) and saves the data into a row/column format in Sheet3 (some of the data in these fields are in paragragh format). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you Export Excel data permanently to Access
Hi WDR,
See Ole P. Erlandsen's suggestions at: http://www.erlandsendata.no/english/...badacexportado --- Regards, Norman "WDR" wrote in message ... How do I export a range of data which is in a row/column format (i.e., row=record, column=field) in Sheet3 to a file that can then be easily imported to an Access table? Please point me in the right direction on the best way to do this. Thanks I am using Excel 2000 & Access 2000 FURTHER DESCRIPTION OF MY CURRENT SITUATION: I have an Excel file that my field techs enter data and print customer reports from. The file contains multiple sheets. Sheet1 is the data entry form. Sheet2 is the report then print which uses the data in Sheet1. Then, before the next job, I have a routine that the techs invoke that clears the input sheet (Sheet1) and saves the data into a row/column format in Sheet3 (some of the data in these fields are in paragragh format). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you Export Excel data permanently to Access
This helps a little.
The access table I want to import to will not be on the techs' computer but rather on a system back at the office. I need to ability to create a file on the tech's laptop that will contain the data I exported from excel. The tech will then email that file to the office. Then the office will then invoke a procedure (in Access I assume) to import that file into Access. Also, note there are multiple techs in the filed that will be sending a file to the office daily. Thanks, -Warren (WDR) "Norman Jones" wrote: Hi WDR, See Ole P. Erlandsen's suggestions at: http://www.erlandsendata.no/english/...badacexportado --- Regards, Norman "WDR" wrote in message ... How do I export a range of data which is in a row/column format (i.e., row=record, column=field) in Sheet3 to a file that can then be easily imported to an Access table? Please point me in the right direction on the best way to do this. Thanks I am using Excel 2000 & Access 2000 FURTHER DESCRIPTION OF MY CURRENT SITUATION: I have an Excel file that my field techs enter data and print customer reports from. The file contains multiple sheets. Sheet1 is the data entry form. Sheet2 is the report then print which uses the data in Sheet1. Then, before the next job, I have a routine that the techs invoke that clears the input sheet (Sheet1) and saves the data into a row/column format in Sheet3 (some of the data in these fields are in paragragh format). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Export from Access to Excel | Excel Discussion (Misc queries) | |||
How can I Export data from to Access to an Excel Template | Excel Discussion (Misc queries) | |||
Exporting data in Excel permanently to Access | Links and Linking in Excel | |||
export data from Excel to MS Access (ADO) using VBA | Excel Programming | |||
Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) |