Download the free trial version
Basic4android Video
Features
Tutorials and manuals
Showcase
Screenshots

Go Back   Android Development Forum - Basic4android > Basic4ppc (Windows Mobile) > Questions (Windows Mobile)
Problem importing CSV file to SQLite Problem importing CSV file to SQLite
Documentation Wiki Register Members List B4P Search Today's Posts Mark Forums Read

Questions (Windows Mobile) Post any question regarding Basic4ppc.

Problem importing CSV file to SQLite

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-28-2008, 05:20 AM
Senior Member
  
Join Date: Mar 2008
Location: Dhaka, Bangladesh
Posts: 164
Default Problem importing CSV file to SQLite
Hi,

I tried to import a CSV file (having 53241 records)to SQLite using SQLite Database Browser 1.3 but it stucks each time. Please help.

Attached is the zipped CSV file.



regards,
Reply With Quote
  #2 (permalink)  
Old 07-28-2008, 08:27 AM
giannimaione's Avatar
Basic4ppc Veteran
  
Join Date: Apr 2007
Location: Naples, Italy
Posts: 244
Send a message via Skype™ to giannimaione
Awards Showcase
Beta Tester 
Total Awards: 1
Default
... imported ...
__________________
Gianni
Reply With Quote
  #3 (permalink)  
Old 07-28-2008, 08:55 AM
Senior Member
  
Join Date: Mar 2008
Location: Dhaka, Bangladesh
Posts: 164
Default
Hi,

Thanks, I appreciate for your effort.
Can I know the name and URL, the application you used ?


Best regards
Reply With Quote
  #4 (permalink)  
Old 07-28-2008, 12:38 PM
giannimaione's Avatar
Basic4ppc Veteran
  
Join Date: Apr 2007
Location: Naples, Italy
Posts: 244
Send a message via Skype™ to giannimaione
Awards Showcase
Beta Tester 
Total Awards: 1
Default
wake up my friend,
i have converted/imported it with BASIC4PPC
__________________
Gianni
Reply With Quote
  #5 (permalink)  
Old 07-28-2008, 02:23 PM
Erel's Avatar
Administrator
  
Join Date: Apr 2007
Posts: 15,733
Awards Showcase
Basic4ppc Founder 
Total Awards: 1
Default
You can load the CSV file to a table with Table.LoadCSV and then convert it to an SQLite table with SQL.CreateSQLTable.
Reply With Quote
  #6 (permalink)  
Old 07-29-2008, 02:40 AM
Senior Member
  
Join Date: Mar 2008
Location: Dhaka, Bangladesh
Posts: 164
Default
Thank You.


regards,
Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQlite problem Ricky D Questions (Windows Mobile) 1 10-04-2008 08:35 AM
Regarding SQLite problem mozaharul Questions (Windows Mobile) 0 04-02-2008 09:28 AM
Another sqlite problem! giannimaione Questions (Windows Mobile) 5 05-13-2007 07:25 AM
Multiple forms and form importing scott93727 Basic4ppc Wishlist 3 05-08-2007 01:36 PM
Problem mit SQLite und CheckBox Fontanus German Forum 6 05-06-2007 03:03 PM


All times are GMT. The time now is 10:08 AM.

Contact Us - Basic4android - Android programming - Top

Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0