?
Solved

convert csv data in excel or access column

Posted on 2013-11-13
3
Medium Priority
?
349 Views
Last Modified: 2013-11-16
Hi,
I have a situation here where I have data in csv format.
'1234', '5678', '9010', '1112', '1314'

i want to populate the values in excel or access in the format, attached in jpg. so basically i want to add another column in access or excel populated with a string value, in this case Summer. any help, comments or feedback would be deeply appreciated.
excel.jpg
xcess.jpg
0
Comment
Question by:s_hausen
[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
3 Comments
 
LVL 11

Accepted Solution

by:
Gregory Miller earned 2000 total points
ID: 39646727
If the data is in a single line and there are not more than will fit in a single row in Excel just import in normally as a CSV which puts the data in one row and multiple columns.

Highlight the row of data and Ctrl-C to copy
Pick the row where you want the column of data to begin and right click
Choose Paste Special and then Transpose

Your data will be in Column format.
You can then add the "Summer" data in the column next to it.
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39653258
Hi,

Do you always have the same format in the CSV file, i.e 5 values per row?

If so you will need to link the file and insert one record for each value into the table along with your desired ItemName = "Summer".

You can use VBA or quickly create 5 successive queries to do this.

If you need help with this let me know.

Regards,

Bill
0
 

Author Comment

by:s_hausen
ID: 39653425
data can be changed all the time. i guess i go and use technoweeb solution. thanks for everyone's help.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

718 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