Append an Access table name

Question

1.00/5 (1 vote)

See more:

I have a daily table that I append to a master table...the last two column are the date the append is being done and the table name that is being appended. I have the date part but is there a way of pulling the name of the table that I am appending from? i.e. I'm appending TrackedData11232013a into TrackedDataMaster how do I add TrackedData11232013a into TrackedDataMaster without having to type it in each time?

Posted 23-Nov-13 4:50am

Runner55Code

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-03T09:28:00

There is no option to import data without specifying the file name of csv file.

You can write query like this:

SQL

PARAMETERS [CSVFileName] CHAR;
INSERT INTO DestinationTable (Field1, Field2, ..., FieldN, FileName)
SELECT Field1, Field2, ..., FieldN, [CSVFileName] AS FileName
FROM SourceTable IN [CSVFileName];

which will prompt you (or any other user) for entering the name of file to import.
Note: it should be the full path and name of csv file!

For futher information about importing data from text file, please see: IN Command[^]