Import CSV data

Importing CSV physician and pharmacy data 

Ok, I finally did it .. imported all 1156 Spokane physicians from my existing CSV table directly into remr.fdb's GPS table using MS Access.  Here's how:

Already had an Access database table for Spokane Physicians, saved to CSV.

Found a free application called CSVed for manipulating CSV files so I could easily merge my existing State/Zip into a single CITY column, which is how GPS stores it, and merge existing FirstName/MI columns into GPS's APPELL column. Changed the column names (FIELD NAMES) to match GPS's column names.

Deleted the primary key column from SpokanePhysicians table.  Graham assured me that Firebird/synapse would autogenerate the new primary keys after import.  He was right, it did.  SpokanePhysicians column also has a lot of duplicate physician name entries for physicians with multiple practice addresses, which Graham also assured me should be no problem.  He was right about that too.  

Launched SpokanePhysicians CSV file with Excel, and saved to excel format to avoid having to make sure all the " " comma delimiters were all correct.  Smart move (long story on that one).

Open remr.fdb with MS Access using Open -->ODBC Databases-->Machine Data Source-->remr

Used Access's "Get External Data-->Import" function to directly import my "doctored up" SpokanePhysician.xls spreadsheet directly into remr.fdb's GPS table (don't forget to check "First Row Contains Column Headings").

Got about 5 errors that only 5 records out of 1156 contained null values and couldn't be imported.  

Very easy overall to do.

JUST TO ADD:  It's a dang good thing Graham made it so I can filter first on Specialty, then filter on Surname with this many entries.  Very nice feature.