|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 17th, 2009, 10:13 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Table Link
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 
|
|
#2
December 17th, 2009, 01:05 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Table Link
My file is not a excel file its .CSV file.
"Ranjith Kurian" wrote: 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
|
|
#3
December 17th, 2009, 03:50 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Table Link
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? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Ranjith Kurian" wrote: My file is not a excel file its .CSV file. "Ranjith Kurian" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
