Table name as parameter in SQL query

[Guest]

Hi,

I'd like to create a query in Access that will prompt me for the table name from which to get the data. Since I'm not very familiar with SQL I normally create a query using the QBE grid, switch to SQL view and make changes.

Ultimately I'm going to use this query from a VB.net program and will be looping through a sequence of tables as my data sources.

I'd appreciate any help, hints or suggestions.

Thanks,

Art

 

[John Vinson]

Hi,

I'd like to create a query in Access that will prompt me for the table name from which to get the data. Since I'm not very familiar with SQL I normally create a query using the QBE grid, switch to SQL view and make changes.

Ultimately I'm going to use this query from a VB.net program and will be looping through a sequence of tables as my data sources.

I'd appreciate any help, hints or suggestions.

You cannot pass a table name as a Parameter to a query; you'll have to
have your VB.Net program actually construct a SQL string.

I'm queasy about your table design - multiple identically-structured
tables are generally A Bad Idea. Are you storing data in tablenames?
What are these tables?

 

[Dale Fye]

Seems to me that you could import to a single table, then update the master
table from there. If there are errors you can always delete a single months
transactions from the master table. No need to store each month in a
separate table and in the master as well. It sounds like you are keeping
the monthly text files anyway, so you could always go back and redo the
entire process.

Dale

 

[Guest]

Dale,

Thanks. I'm trying to do much of my work through VB.net -- something I'm just learning. I'll pop over to that discussion area to find out how to submit a command such as application.docmd.trasfertext - so that I may be able to do what you suggest.

Art