Take the 2-minute tour ×
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.

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][1] [1]: stackoverflow.com/questions/1045910/… –  Rohan 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 stackoverflow.com/questions/10557360/…) and then import the csv.. I don't think there is a direct way.. –  Rohan Jun 11 '13 at 12:14
add comment

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.