Search found 5 matches
- Tue Jan 01, 2013 8:16 pm
- Forum: Databases
- Topic: Manipulating a large CSV file (beginner question)
- Replies: 9
- Views: 9698
Re: Manipulating a large CSV file (beginner question)
Happy New Year! I've made some progress. I exported out my database from MS-Access and was able to create a SQLite database using a Firefox SQL database manager. Now I will go back to my code and see if I can open and not get the revdberr. Yes, I'm using the revDataFromQuery. Here is the code segmen...
- Sat Dec 29, 2012 11:22 pm
- Forum: Databases
- Topic: Manipulating a large CSV file (beginner question)
- Replies: 9
- Views: 9698
Re: Manipulating a large CSV file (beginner question)
Yes, it is in a Access database and could stay there instead of exporting out to a csv or other txt file. I'd like to do open it on a Windows or Mac. My first task is to open it up and then search for a partnumber. I could send a sample script that I've written already to open and then get the data....
- Sat Dec 29, 2012 1:55 am
- Forum: Databases
- Topic: Manipulating a large CSV file (beginner question)
- Replies: 9
- Views: 9698
Re: Manipulating a large CSV file (beginner question)
I got off trace for a few months with other projects and am back on this task. Now I clearly realize that a ODBC link will be a better choice. Do you agree?
Will
Will
- Wed May 18, 2011 9:59 pm
- Forum: Databases
- Topic: Manipulating a large CSV file (beginner question)
- Replies: 9
- Views: 9698
Re: Manipulating a large CSV file (beginner question)
Thanks for your response to my question. That helps immensely. I did another look at how my data file is formatted. It is actually a text file (.txt) with a ~ delimiter. I can export the data with a different delimiter but I don't think that will matter. The file consists of records that have a prod...
- Mon May 16, 2011 6:45 pm
- Forum: Databases
- Topic: Manipulating a large CSV file (beginner question)
- Replies: 9
- Views: 9698
Manipulating a large CSV file (beginner question)
Hi, I've signed up to the seminar to learn LiveCode for enterprise deployment of iPad applications. My first is an app that allows sales people to search a large price list to create a request for quote with a customer. the database for the pricelist exist as a CSV file of about 160,000 individual p...