>I am facing problem when importing data from Excel 97 & operating system windows 98.
>In the Excel sheet coloumn b is a date coloumn. ( all the values are date value no header row)
>Foramt of this cell is Custom MM/DD/YYYY. I also tried various Types in Date format Categeory.
>I am using Import and Append Command. Import column converts the values in to numeric data type.
>while using Append command date field is left blank.
>I also tried import Wizard but faced same problem.
>
>I have also tried changing windows regional settings.
>
>There is no problem if use same commands in excel 2k.
>
>Please Help
lcXLS = 'fullpath\xlsname.xls'
oExcel = CREATEOBJECT('excel.application')
oExcel.Displayalerts = .f.
oExcel.WorkBooks.Open(lcXLS)
lcfilename = SYS(5)+CURDIR()+'yourtable.dbf'
oExcel.ActiveWorkBook.SaveAs(lcfilename,8)
oExcel.Activeworkbook.saved = .t.
oExcel.Quit()
Cetin