Frequently Asked Question
How to Create Database in Microsoft Excel 2003/ 2007/ 2010/ 2013 for CS200/ CS220/ CS310/ CS320
Last Updated 5 years ago
How to Create Database in Microsoft Excel 2003/ 2007/ 2010/ 2013Step 1: Getting start
Install Microsoft Excel 2003/ 2007/ 2010/ 2013 in your computer, press Start > Program Files > click Microsoft Excel
After click MS-Excel it will open Excel application window in that go to file > select “New” option or simply click new button on the tools bar. The Microsoft Excel opens a window on the right side as shown below.
After open the empty Excel file type the field which you want (Ex: A1 cell for Emp_ID, B1 for Emp_Name, and C1 cell for Emp_Age etc…) then enter all the records (information) to the corresponding fields as shown in below
Note: make sure the field Emp_PhotoID is same as corresponding person ID PHOTO file name – to avoiding confusion better to make PHOTOID file name as a Emp_Id field because Employee ID is unique number for each employee.
Once the entry is over select all the records as shown in below
Then go to insert menu – Name – Define, as shown in below
Type a valid name for the Define Name ( it is like TABLE name in the database) Click OK button
After that save the Excel files in the local disc
How to Connect Microsoft Excel Database file into Card Desiree CSStep 1: create templates
First create templates as per template usage and layout designing of requirement.
It might be confusing if you don’t change the mapping layer’s name as to the ones we created to the Microsoft Excel: So it’s suggested to enter the same to map with the same fields.
Recommended to save the template for precaution:
Step 2: connecting the database
Starts connecting the database by selecting “connect database” option in the Card Desiree CS.
Step 3: Creating Data Sources
In this screen we removed all preset default data sources for clearer view. Press the ODBC Administrator
The ODBC data source screen will appear, press ADD
Please select the “Microsoft Excel Driver [*.Xsl]” driver
After select Finish the following screen will appear
Enter the Data source name as below and then select “Select button” for selecting the path of the Microsoft Excel Database file.
Below dialog box shows selecting database files path. After select correct file click “OK “button
After you click the dialog box will shows the path. And then click “OK” After click “Ok” Button the “ODBC Data Source Administrator” windows shows the Driver for Microsoft Excel. Click “OK”
After click “Ok” the “available Data Source” windows does not shows the just create Data Source you have to click “Refresh“ Button
Note that when you press Refresh button you will get “CS300_Excel_DATASOURCE data source in the list. After select the data source click “Next” Button.
The next window show “Available Table and Views” in the Database, if you have more then one tables select correct one for creating mapping
After select table click “Finish” button
Note that when you press ‘Finish” Button, the Card Desiree CS bring the entire fields name from the table which you select previously.
Ignore the error message
Step 4: Start mapping the data source to the Card Desiree CS
Start mapping each layer in the template:
Select the field and select the ODBC source
After pressing OK, the source will show ODBC source properties in that we have to select the correct column name field as previously we suggested having the same name as to the template.
The Layer Name in the Card Desiree CS will be connected after press APPLY Button.
As shown in the screen do the same mapping procedure for all the TEXT fields.
Image mapping is a little bit different from the TEXT mapping, first select the image Layer name and then select the ODBC source (pointer to a file name), after selecting the right folder which contains the image files to the source properties then it will ask path for the prefix (images path which we stored in the disk) select the path and press OK.
Select a column name and suffix and select the image type (.jpg or gif or bmp etc…) that are stored in the disk, and then press APPLY.
The following figure shows the image mapped correctly
Linking of Microsoft Excel database to Card Desiree CS is completed, you can check by using the buttons circled in blue to check the data are connected or NOT.