Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Import Selected Data
.....from an Excel CSV file into my Excel/VB Macro application.
Briefly, I have developed an Excel application that runs as a macro - completely hiding Excel. I have another application (not written by me) that exports its data into a comma delimited file readable by Excel. I wish to extract certain columns from that particular file, compare it to the data that is already stored in my application, updating the fields as necessary. My initial idea is to completely load this huge file into a worksheet within the application, strip it down to the necessary columns, and then programatically compare data, inserting and deleting where necessary. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Import Selected Data
It would easier if your data was also saved as a delimited file. you then
just diff the files. Its definitely not optimum to have your data within the application. You could achieve the same result with an Access application. The beauty of MS Access is that you can very easily import a csv file to a temporary table and use a simple update query to amend your base data. You would need to open teh csv file within excel. and then using a VLOOKUP map your data to the imported data, changing your data where applicable. "roy_ware" wrote: ....from an Excel CSV file into my Excel/VB Macro application. Briefly, I have developed an Excel application that runs as a macro - completely hiding Excel. I have another application (not written by me) that exports its data into a comma delimited file readable by Excel. I wish to extract certain columns from that particular file, compare it to the data that is already stored in my application, updating the fields as necessary. My initial idea is to completely load this huge file into a worksheet within the application, strip it down to the necessary columns, and then programatically compare data, inserting and deleting where necessary. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Import Selected Data
Aye - Access is a much better product for this application, but the company
is too cheap to spring for it - so I am left trying to solve it with Excel. Thanks for the vlookup idea - hadn't occured to me. "Patrick Molloy" wrote: It would easier if your data was also saved as a delimited file. you then just diff the files. Its definitely not optimum to have your data within the application. You could achieve the same result with an Access application. The beauty of MS Access is that you can very easily import a csv file to a temporary table and use a simple update query to amend your base data. You would need to open teh csv file within excel. and then using a VLOOKUP map your data to the imported data, changing your data where applicable. "roy_ware" wrote: ....from an Excel CSV file into my Excel/VB Macro application. Briefly, I have developed an Excel application that runs as a macro - completely hiding Excel. I have another application (not written by me) that exports its data into a comma delimited file readable by Excel. I wish to extract certain columns from that particular file, compare it to the data that is already stored in my application, updating the fields as necessary. My initial idea is to completely load this huge file into a worksheet within the application, strip it down to the necessary columns, and then programatically compare data, inserting and deleting where necessary. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should be able to import selected data from MS Word | Excel Discussion (Misc queries) | |||
import sheets of name selected | Excel Programming | |||
Can you save options selected in Text Import Wizard? | Excel Programming | |||
Import selected data | Excel Programming | |||
Import selected lines from an Ascii file | Excel Programming |