Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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 Habib Mar 14 at 12:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.