Hi,
Table Patient includes:
ShortID (primary key)
Long ID (medical record number)
Patient name
Demographics, etc.
Table Test contains
ShortID
...plus several fields related to a specific medical test
I have a .csv file that contains Long ID from Table Patient and Table Test fields, but not ShortID
I know that I can do bulk insert, but I only know how to do it to insert data into an empty table. How to I insert my CSV data into Table Test without the ShortID?
Thanks!