Use an Excel Data-Base with eMedia-CS
Use an Excel Data-Base with eMedia-CS
eMedia-CS allows you to connect to a Microsoft Excel Database in all versions (Standard, Pro & Expert). You want to create your own Database ? Here are the steps to follow:
1. Creating the Excel File :
Open Microsoft Excel and create a new table. Databases are all structured as columns. The first line is reserved for field names.
Note : The first line should contain none of the following characters: \ / : * ? " < > | and "space" and none of these words:
After filling in the first line, save your Excel file, taking care to remember the type of extension you used (".xls" or ".xlsx").
Mediasoft
Page 1/5
Use an Excel Data-Base with eMedia-CS
2. Excel Database connection with eMedia-CS
After launching eMedia-CS, go to "Design" mode and press the "Connect your template to your Database" (or Tools -> Connect to Database) If your file extension is ".xls", select MS Excel 97-2003 If your file extension is ".xlsx", select MS Excel 2007-2010
Note : if you have a 64bit Excel installed, please refer to "5. Special case: S6?4lebcitioMnincreozsaolfotrEsxvcoetlr"eafticthieerenExdcoefl ethteapdpoucuyemzesnutr. ? suivant ?. "5. Cas particulier : Microsoft Excel 64 bits" en fin de note. In the "Additional information regarding the handling of the connection", don't fill anything and press next. Select the sheet in which your database is and press "next". Choose Authorizations that eMedia-CS can have on the database (Modify, Add and Delete records) and press next. Select the fields that will be displayed and can be edited then press next. Once this process is finished, you just have to match the fields in your database with the fields on your eMedia-CS template.
Mediasoft
Page 2/5
Use an Excel Data-Base with eMedia-CS
3. Correspondence with the template fields
Select your object on your template. In "Source" select "Database field" and then make the match with your object.
You may repeat this operation as many times as there are objects that you want to connect to your database.
Mediasoft
Page 3/5
Use an Excel Data-Base with eMedia-CS
4. Batch printing
Regarding the ? batch printing ? here are the steps:
Activate the "operating" mode and select the magnifying glass to bring up the search window in the database mode.
Go to "records", enter the first record you want to print and the last.
Click on the "print" button, then the software will print from the first record to the last specified.
In the picture above, The first line to be printed will be recording 1. The last line to be printed will be recording 5. The printed records will be: 1, 2, 3, 4 and 5.
Note : the first Excel line being taken by the field names, the line number is shifted with respect to the registration number. Registration X is now X+1 In our example, the first record matches line 2 and the 5th matches line 6. Print records 1 to 5 matches printing lines 2 to 6.
Mediasoft
Page 4/5
Use an Excel Data-Base with eMedia-CS
5. Special Case : Microsoft Excel 64 bits
Since Microsoft Excel 2010, 64 bit versions of the software are distributed. However we noticed some compatibility problems with eMedia-CS and the Database connection. The solution for your 64 bit Microsoft Excel Database to be readable by eMedia-CS is as follows:
1. Open your Microsoft Excel Database.
2. Save in ".xls" format.
3. Launch eMedia-CS and choose "Microsoft Excel worksheet (MS-Excel 972003)" in the Database connection.
Mediasoft
Page 5/5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- use an excel data base with emedia cs
- qu apporte la version 9 4 de sas pour ecrire lire des
- format d échange de données entre fabricants et distributeurs
- ouvrir un fichier excel sur android
- travaux pratiques excel 2013 dunod
- import excel — import and export excel files
- v 64 bits de et vos fichiers microsoft office
- pierre rigollet c est un cahier d exercices excel 2016
Related searches
- why use an offset cane
- excel data entry form with dropdown
- how to use an excel spreadsheet
- when to use an apostrophe with names
- when do you use an and a
- exercise ball base with wheels
- ball chair base with wheels
- why use an lms
- data analysis with excel examples
- how to use an in a sentence
- when to use an vs a
- use an or a