djdellux Posted December 4, 2008 Share Posted December 4, 2008 I need to create a db in SQLite from an excel file. the file has been converted into a .csv... i am havin some problems with ths any suggestions guys???? Quote Link to comment https://forums.phpfreaks.com/topic/135493-solved-need-help-making-a-table-for-this/ Share on other sites More sharing options...
.josh Posted December 4, 2008 Share Posted December 4, 2008 I suggest you explain what the problems are. Quote Link to comment https://forums.phpfreaks.com/topic/135493-solved-need-help-making-a-table-for-this/#findComment-705853 Share on other sites More sharing options...
djdellux Posted December 4, 2008 Author Share Posted December 4, 2008 well i have never used sqlite before... i am in the process of my normal stuff ie gogle and other searching, but i always try to ask everyone here because i always find myself getting the best info from the pros Quote Link to comment https://forums.phpfreaks.com/topic/135493-solved-need-help-making-a-table-for-this/#findComment-705855 Share on other sites More sharing options...
.josh Posted December 4, 2008 Share Posted December 4, 2008 yeah but...what's the problem? Trying to install sqlite? Trying to import the csv file? what? Quote Link to comment https://forums.phpfreaks.com/topic/135493-solved-need-help-making-a-table-for-this/#findComment-705857 Share on other sites More sharing options...
djdellux Posted December 4, 2008 Author Share Posted December 4, 2008 I have the db created but I'm not sure how to insert the csv info into it. the csv file is quite extensive. 16 col/600+ rows but it also needs to be continuously updated... i am told it is an accumulation of 4 different files as well... first time for that lol... Quote Link to comment https://forums.phpfreaks.com/topic/135493-solved-need-help-making-a-table-for-this/#findComment-705859 Share on other sites More sharing options...
.josh Posted December 4, 2008 Share Posted December 4, 2008 Ah. So you want to import a csv file into your sqlite db. From the command line? Got some UI? http://www.google.com/search?hl=en&q=import+csv+file+into+sqlite+database&btnG=Google+Search Quote Link to comment https://forums.phpfreaks.com/topic/135493-solved-need-help-making-a-table-for-this/#findComment-705884 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.