I have a MS Access database that has 9 columns what I want to do is to retrieve all data from a database only on 5 columns.
I think I have to use the
select * from data but I don't know how to select the columns I want to retrieve because I can't use the
WHERE test = '" because I want to retrieve all database records but only selected columns.
A very good example of what I want to achieve is this
select all usernames, birthdates, last_seen_status now this is just an example where a database has users records in the database you may have as many columns as possible including name, surname, sex, location, username, last_seen_status,birthdates, registration_Date and more but only need to retrieve data from 'username,birthdates,last_seen_status` from the database for all the users that had registered or is registered in this database.
Hope I didn't confuse you on this. I saw something with
wildcards but was a bit complicated the problem is that I didn't know how to apply it to my scenario. I saw it here: http//www.codeguru.com/columns/vb/doing-data-extraction-with-visual-basic.net.htm