weird issue importing from excel to TD.....

Database
N/A

weird issue importing from excel to TD.....

Hi All,

I am encountering an issue trying while I am trying to Import data from Excel to a TD table that is driving me a bit nutty.

I keep getting the 'Wrong number of data values in Import file' error, even though my .csv file has the same number of data-values as my TD table.

I've even tried doing the import with just one column in the TD table and one column of .csv data, and I STILL get that error. This is really stumping me. Anyone ever encounter this issue?

TIA,

myk
4 REPLIES

Re: weird issue importing from excel to TD.....

I guess the delimeter that is used as default in your import/export option is set to something other than comma.

In queryman check this (click on the follwing menu option)
Tools -> Options -> Export (tab)
now change the Use this delimiter between columns in export/import files
from the dropdown choose ,

click ok

Now try the Import Data.

Let me know if that does not work.

Re: weird issue importing from excel to TD.....

Hi,
Also Some time it throws same error if there is a date column.In the excel sheet you need to format the date column to yyyy-mm-dd.

Thanks,
Gowda C H
N/A

Re: weird issue importing from excel to TD.....

Mike,

You may want to remove all column header information from the export report file. This should help.

For the date issue, you will need to change the format to match the date format (for the column) in the table.

Hope this helps.

Vinay

Re: weird issue importing from excel to TD.....

I am getting an error "Data Values Missing in Record #' though the excel has rows for the record and more.

It has started happening recently on a couple of files that I started loading.