Importing MS Sql database into Clarion database (.TPS)

[CarlBarnes]

@donridley

Import the SQL table into dictionary.
Loop through SQL table and insert into TPS

An easy way to “Loop through SQL table and insert into TPS” …
… is to use a Process Template to create a Procedure that Reads the SQL and does an ADD to the TPS.

The DCT has the ability to “Generate Conversion Program” that makes a Standalone EXE with the file definitions. Best for a 1 time thing. Its all source so if the file definitions change you’ll have to edit the source. The above Process template procedure uses the DCT for file specs so is more future proof.

@donridley

Export SQL to CSV.
Loop through CSV and insert into TPS.

The CSV import method can make use the DCT Import feature as shown in the below topic.

How to import CSV into Clarion 11 TopSpeed file without writing code

TopScan has an Export to CSV that I often use, I agree it would be very useful if there was also an Import. My method is not “code free” but it is mostly generated. Define the CSV File in the DCT (see import below). The DCT lets you browse file to see its right. For a 1 time convert use the DCT conversion, or if you’ll be doing this often… In an APP generate a Process to Read the CSV and Add to the TopSpeed. You’ll have to code those assignments and convert types. To help you can wizard a Bro…