Best method to insert data into 500 tables in SQLITE

[rex]

Hello sir, thank you for your time.

i am sorry that was a mistake. i meant 500 columns not tables.

i am in a fix on how to go about inserting data for 500 Channels into 500 different tables.

I think a table with three columns will do it and will even adapt easily to the arrival of a 501st channel

I think a table with three columns will do it and will even adapt easily to the arrival of a 501st channel

To copy to clipboard, switch view to plain text mode 

but i might have different data for each column for Channel , so i though i must have 500 columns to save each channels data. How could i use a table of only three columns to accommodate 500 different channels of data.?
I did go through sqlite faq to find some answer but din't find any.

thank you