How to use a excel file to create a service component?
Dear all,
I want to use a excel file to create a service to be my data source. I used the wizard to do that but i always got a message. "The data format is not valid, fields in each record must be delimited by tab charactors, and each record seperated by new line charactors". How should I reformat my excel file to fit the requirements? I have already chang the field`s format into 'text' type. Thx ^^
Hi Louis,
You said that fields in each record must be delimited by tab charactors, and each record seperated by new line charactors,
I'm not sure I'm getting you.
Can you clarify, or even write a sample dummy data that illustrates the output you desire ?
For example: http://www.box.net/shared/51rj7k8nm3
Guest replied