Appending Table name into another table table thru SQL query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,
I might be going at this the wrong way so please feel correct me if I am off
the reservation of best practices here. I have an VBA import procedure that
runs daily. It picks up 8 different text files and puts them in 8 different
Access tables. Immeaditly after each Import completes it appends in the
timestamp of when this is performed. Then it moves on to the next
import...etc.....
What I would like to be able to is append the tablename, time stamp into
another table so that it can be reference easily. Am I thinking in the right
direction here? Any suggestions?

Thanks a ton! Have a good weekend
 
Plumdodge said:
All,
I might be going at this the wrong way so please feel correct me if I am off
the reservation of best practices here. I have an VBA import procedure that
runs daily. It picks up 8 different text files and puts them in 8 different
Access tables. Immeaditly after each Import completes it appends in the
timestamp of when this is performed. Then it moves on to the next
import...etc.....
Click to expand...

This is all understandable.

What I would like to be able to is append the tablename, time stamp into
another table so that it can be reference easily.
Click to expand...

This is not. What good would appending the tablename into each row
do? You already know the table names, they don't belong inside the
rows themselves. If you need that, and since you are already
writing *VBA* code, then just refer to it via DAO.

Am I thinking in the right direction here?
Any suggestions?
Click to expand...

Without more information, it is difficult to know.

Although meant for an SQL Server newsgroup, the
following link is still applicable for MS Access:
http://www.aspfaq.com/etiquette.asp?id=5006, and
is excellent when it comes to detailing how to
provide the information that will best enable
others to answer your questions.


Sincerely,

Chris O.
 
Back
Top