Insert Into SQL Question.

[Robeen]

I have Insert Into SQL that I use in a function and it works.
In it I specify the field names in the target Table and the respective Values that I want inserted.

Is it possible to do a 'generic' insert where I just say something like [pseudo code]:

Insert Into TableB . . . no field names specified . . .
In "\\Path\DBName.accdb"
Everything from TableA where MyDate is Date() -30

??

I want to archive data from several Tables into their Identically-Structured Archive replica Tables in another DB using that Date() - 30 filter.
I'm thinking of passing the Table Name and its Date Field Name into the SQL without having to pass in a field list for each of the Tables.

I hope I've explained what I need clearly.



Thanks!!

[pbaldy]

Per MS:

When individual columns are not designated, the SELECT table column names must match exactly those in the INSERT INTO table.

[Robeen]

Thanks, Paul!
The target table is cloned from the source table [structure only].
There was also the issue of key fields . . . [I was repeatedly trying to insert the exact same data because I only have limited data to work with in the development environment right now].
Plus - there was an auto number field as well.
Appreciate your help.

[pbaldy]

No problem! Can't recall if autonumber field is a problem in Access. It can be done in SQL Server, which I work with most of the time.