First, before you run asql.exe, set the expert mode environment variable as follows:
ASQL_EXPERT_MODE=1
1) Run asql and select the file that you wish to import the schema for.
2) Click on the "Show Script" button. The "create table" script should be displayed in the lower window.
3) Remove all of the comment lines from the script
4) Change field names to suit your purposes
5) Remove the last ";" from the very end of the script
6) Click on the "Try Again" button.
7) If "OK" is displayed, then everything probably worked as expected.
8) If there is an error, drop the table and try again.
9) WinSQL can be used to verify that the table, field names, and indexes were created as expected.
|