Subject Re: dbimport2 From Gaetano D. <gaetanoddRemoveThis@andThatHotmail.com> Date Tue, 1 Jun 2021 05:22:21 +1000 Newsgroups dbase.getting-started On 1/06/2021 02:27, Mustansir Ghor wrote: > Dear All > > I am trying to import from Excel Worksheet into a dbf table using dbimport2. But it hangs. > > I am attaching the excel file and snapshot of program. > > I would request somebody to find the error may be it is in my excel file. > > Thank you > > Best Regards > Mustansir I do not have DBFImport, so I don't know whether it uses a native driver, an ODBC driver, ole automation...etc. but here are some tips to determine where the issue is: 1. Create a simple Excel file with English characters and numbers with just a few rows and try to import it 2. create a file with Urdu characters and see if that works too if both the above tests work, there is likely an issue with the file you are trying to import: 1. Look for empty (possibly hidden) columns and rows, illegal characters in field names 2. look for illegal data content, e.g. in a date field, empty dates may just be empty or may have any other content representing an empty cell such as "-", "null", "N/A"...etc. and once the data type is determine to be a date, those values could cause issues. 3. look for any formulas that may confuse the import process (to eliminate formulas, copy the entire sheet then right-click and select Paste Special - Values , this will replace the formula with the value that the formula evaluates to) 4. look for any graphic elements that may confuse the conversion program (charts, pivot tables) 5. look for illegal characters in field names (I would think that a conversion tool can handle spaces or illegal characters for field names but it is worth a check) 6. look for merged cells as this would cause issues I do have a conversion routine but it is still at early stages of development. It will import an Excel file using the first line as field names but all fields will be imported as CHAR(30). If you think you can use that for your current needs, I can post it here. Finally, since DBFimport is a product of dBase LLC, I would suggest you submit a bug report when you determine what is causing the issue so they can fix that hurdle in the conversion process, if possible with a sample Excel file that causes the issue without any sensitive data included of course. HTH -- Gaetano.