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?

Have you tested it?

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

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?

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.

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!!