s_hausen
asked on
convert csv data in excel or access column
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
data can be changed all the time. i guess i go and use technoweeb solution. thanks for everyone's help.
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