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???? 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. 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 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? 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... 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 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
Archived
This topic is now archived and is closed to further replies.