Hi Vijay,
I do not know which language you are using to read the CSV file so I will give you some language independent solution.
I have no idea about this "jexcelapi "
butr you can read the CSV file in 2 ways.
1. If you are using any Microsoft technology for this perpouse say VB, VC, C#, ASP .Net etc.
One of the way could be to create an Excel object . Open the CSV file in it. You can run your SQL queries on the excel object datatable.
2. anotherway is to open the csv file in text format.
This is the best way if you have only one sheet in your CSV file.
Just open the file in Notepad and you will see all your data stored. So you can open the CSV file in Code just as any text file and read it line by line to read data.
I think you will find this helpful.
Happy Programming..
Avadhoot
vijay gopinath <[EMAIL PROTECTED]> wrote:
Hi All ,I have a MS Excel CSV file at hand , as my DB. Now , reading the same is a problem . If it was a MS Excel file I could have used jexcelapi : As I do have my file in a CSV format , using this API works fine/not - I have no idea . Any pointers on the same would be great.TIA ,Vijay
Start your day with Yahoo! - make it your home page
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
YAHOO! GROUPS LINKS
- Visit your group "tech4all" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
