Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Import a CSV and save changes only Excel

Posted on 2013-11-12
5
Medium Priority
?
408 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
  • 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 1000 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
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 …

916 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