Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

file name included when importing

Status
Not open for further replies.
scottian

scottian

Programmer
Jul 3, 2003
955
GB
When importing a file into access , is there a way to tag the filename that you are importing into a feild on the table you are importing to.
 
Sort by date Sort by votes
The best thing to do is to do an update query and put the name in each of the records after importing. I am assuming you are just trying to tag each record so you know where they came from.

Network Security( CCNA, CISSP)
Sell Shopping Cart/Merchant Account
Access Expert
rsmith@litsllc.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
297
dhookom
dhookom
v5652
  • Locked
  • Question
Ribbon icons missing each time when MS Windows 10 update
Replies
0
Views
146
v5652
v5652
Jaime_78
  • Locked
  • Question
DoCmd.OpenReport Hangs when user wants to select location of report to save to
Replies
2
Views
125
Jaime_78
Jaime_78
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
108
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Searching for a way to get Access to retrieve and use data from a hard drive file not within Access 3
Replies
13
Views
243
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top