Solved

Import a CSV and save changes only Excel

Posted on 2013-11-12
5
404 Views
Last Modified: 2013-11-13
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
Comment
Question by:Kristoffer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39642535
<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
 

Author Comment

by:Kristoffer
ID: 39642661
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39642691
did you try what i suggested above?

post here which way you want to do this.
0
 
LVL 4

Accepted Solution

by:
azeempatel earned 500 total points
ID: 39643910
Open Excel (any version)

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

this will open import file ... choose your file.
0
 

Author Closing Comment

by:Kristoffer
ID: 39645683
Thanks for the ALT d keystrokes made the process I was doing manually a little slicker and made the documentation even easier
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question