|
|
Seleccione su Idioma/Select your Language:  |
Using the system Coffee SQLStep 1. Building the Excel file:This has only 4 basic rules to consider, and that must be met to ensure the smooth operation of the system. a) The first line represents the name of the fields b) Start from cell A1 to the end where the fields, without spaces between them c) Do not use decorations such as background colors or lines marked d) Do not combine cells Step 2. Starting the Coffee SQL: (must accept the certificate to can start the Coffee SQL)... Here you should just put the name of the table to be create, indicating whether we want to add files or just create the table and we can continue. Step 3. Importing files and resized images (Optional - only applies if we are to attach files, non free web service): In this step should only be putting the size of the images and the folder where are all images or files (the system reads all the files from a folder, ie, files that are attached to the sql query should be all in a single location). Step 4. Generating the query: In this step only remains to wait several seconds or minutes while the system read the file and transforms, because it takes a little more if you must attach file. ¡¡¡ Exito !!! Everything went perfect, the only remaining copy in the SQL statement and run it wherever you need it! |