Import a CSV and save changes only Excel
I have an application that Outputs a csv file from a data base.
I need to manipulate the list in a spreadsheet
I need a tempory solution to be able to import a new version of the CSV into my spreadsheet and only add any additional records.
This needs to be simple and raw. There is a whole project involved with data reporting out of this App but I cant wait for that to get started.
on second thoughts maybe MS Access has a wizard.....
I need to manipulate the list in a spreadsheet
I need a tempory solution to be able to import a new version of the CSV into my spreadsheet and only add any additional records.
This needs to be simple and raw. There is a whole project involved with data reporting out of this App but I cant wait for that to get started.
on second thoughts maybe MS Access has a wizard.....
ASKER
It is a custom application that only has an export to CSV option.
For now the activity just needs to be raw and dirty. We are having web bassed reports delivered from a different project
For now the activity just needs to be raw and dirty. We are having web bassed reports delivered from a different project
did you try what i suggested above?
post here which way you want to do this.
post here which way you want to do this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the ALT d keystrokes made the process I was doing manually a little slicker and made the documentation even easier
is this application an access database?
if it is, you can export the data to an excel file .
* you can import the CSV file to an Access table (need to create an import spec first)
- you can manipulate the records then export it again as a csv file
- or export the records to an excel file
* note that you can open the the CSV file from Excel and save it as an Excel file, have you tried doing this?