1

I have an issue with importing .xls file into SQLite database. I am working on windows xp and using a SQLite manager for maintain the database. I can import the .csv file to the database by using availabel options in menu bar but I can't import the .xls file into this. I want to directly import the .xls file without converting into .csv file.

If I use the .csv file for import the data then it doesn't give the proper output due to comma separation.

Is there any way to import like this? Please give me the proper solution

I already googled but no solution I got.

  • 2
    You could save it as a csv (or use a tool to that) and do this – WrinkleFree Jun 11 '13 at 11:16
  • Rohan@: I already checked that link and I maintioned that I want to directly import from .xls file – Ghost Answer Jun 11 '13 at 11:26
  • 1
    you can first convert it to a csv (using a tool like this one) and then import the csv.. I don't think there is a direct way. – WrinkleFree Jun 11 '13 at 12:14
  • This online tool can convert from xls or xlsx to SQLite: converttosqlite.com Full Disclosure: I wrote it - hope it helps! – Code Slinger Sep 22 '14 at 4:57
  • Try this python code exceltosql – Shahzeb Qureshi Mar 14 '16 at 12:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.