• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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.....
0
Kristoffer
Asked:
Kristoffer
  • 2
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
<I have an application that Outputs a csv file from a data base.>

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?
0
 
KristofferAuthor Commented:
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
0
 
Rey Obrero (Capricorn1)Commented:
did you try what i suggested above?

post here which way you want to do this.
0
 
Azeem PatelSystem AdministartorCommented:
Open Excel (any version)

Start pressing one by one ...... Press Alt > D > D > D

this will open import file ... choose your file.
0
 
KristofferAuthor Commented:
Thanks for the ALT d keystrokes made the process I was doing manually a little slicker and made the documentation even easier
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now