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.