Importing from within

[Mental]

I have a table named "meds" that has a medication list. I would like to import these records into another table named "scheduler" on a daily basis. Is it possible to import files from one table to another in the same database?

[IdealData]

Have you tested it?

Even if you can't import, you would still be able to script it.

[Mental]

I've tried to script it but no records import. If I try to import from an external file it works. What could I be missing?

[IdealData]

Sorry, when I said script it I meant you would able to generate a script that would build new records from the (related) table.

The Import function does not work because it is based on a FILE, not a TABLE.

Of course, you could EXPORT and then IMPORT - and that could be scripted too.

[Mental]

How do I create a script that would build from a related table? I can't do the import/export method because I need keep with HIPAA compliance and not have any non-password protected files lingering out there. Also, keeping with just one file keeps things organized in my world Any help would be GREATLY appreciated!!