john smithmyer
New Member
- Joined
- Nov 29, 2008
- Messages
- 45
I have a data source with 20 fields. I created an export “template” that exports 8 of the 20 fields to a tab delimited text file.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I also have an Excel spreadsheet (with visual basic code) that imports this data ( 8 fields) and processes it into a report.<o></o>
<o></o>
The eight fields are:<o></o>
Date 05/26/2012<o></o>
View Good<o></o>
Temp 78<o></o>
Size 8<o></o>
Cap Yes<o></o>
Bad No<o></o>
Run Yes<o></o>
Color Red, Blue, Green<o></o>
<o></o>
When exported from the data source, if Color has more than one entry it creates duplicate fields for each one like this:<o></o>
Date View Temp Size Cap Bad Run Color Color Color<o></o>
05/26/12 Good 78 8 Yes No Yes Red Blue Green<o></o>
<o></o>
Any ideas on how I can import this data into my Excel application which would combine the “like” fields into one before processing?<o></o>
<o></o>
Thanks as always for your kind assistance!<o></o>
<o></o>
John<o></o>
<o></o>
I also have an Excel spreadsheet (with visual basic code) that imports this data ( 8 fields) and processes it into a report.<o></o>
<o></o>
The eight fields are:<o></o>
Date 05/26/2012<o></o>
View Good<o></o>
Temp 78<o></o>
Size 8<o></o>
Cap Yes<o></o>
Bad No<o></o>
Run Yes<o></o>
Color Red, Blue, Green<o></o>
<o></o>
When exported from the data source, if Color has more than one entry it creates duplicate fields for each one like this:<o></o>
Date View Temp Size Cap Bad Run Color Color Color<o></o>
05/26/12 Good 78 8 Yes No Yes Red Blue Green<o></o>
<o></o>
Any ideas on how I can import this data into my Excel application which would combine the “like” fields into one before processing?<o></o>
<o></o>
Thanks as always for your kind assistance!<o></o>
<o></o>
John<o></o>