Table Link

  • Thread starter Thread starter Ranjith Kurian
  • Start date Start date
R

Ranjith Kurian

When i link the excel file in Tables objects using Link Table wizard, in one
of the step the wizard ask 'Choose the delimiter that separates your fields'
here when i tick Comma to separate the fields, the problem iam facing here
is even my data/content other than heading also got separated as the data
contains comma.

I have 25 excel workbook to be linked, so its not easy to copy each excel
file manually into new designed table

example
question:
customerName,Amount
bonney,A,12000

Answer:
CustomerName Amount
bonney,A 12000
 
That's one reason that files are often exported to text or CSV with quotation
marks surronding the data in the fields. That way the commas between the
quotation marks are ignored.

Can you request a change as to how the CSV files are created?
 
Back
Top