Table Link

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
 
J

Jerry Whittle

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Import Question 0
Split delimited field data TWICE to populate specific other fields 3
Importing Text File with Strange Delimiter 4
Pasting a cell into bookmarked table from excel vba 1
Importing from a Notepad file 3
Link to excel table which has keys in both row and col headers: isthis possible? 0
Extract data in rows (with line breaks) to form a table 0
open csv file 1

Top