Hi
I have setup 2 databases with item data. One is a SQL table and the other is from an excel sheet.
The SQL table contains "Item_no", "Description" & "Qty", The Excel table contains the "Item_no" & "Barcode".
Is there a way that i can link the databases together via the "Item_no"?
Linking Databases in Designer 2019
Moderators: Georges, milos, NiceLabel Support Team
- dado
- NiceLabel Development
- Posts: 670
- Joined: Tue Sep 12, 2006 12:50 pm
- Location: Kranj, Slovenia
- Contact:
Re: Linking Databases in Designer 2019
Yes it is possible.
You need to open the Data Menu / Dynamic Data Manager
Now select your SQL Table in the left part of the dialog
On the right side select Filter and Enable it.
Select which field you want (Item_no in your case)
And select the compare sign =
And on the right side select the Excel field called Item_no
I have a sample for you. But first you'll need to create on your local SQL Express server (if you have one) a database called TEST and in that database a table called Test1.
Then just download the NiceLabel solution and the .xlsx file and place then in the c:\tmp\ folder
Open the sample and you'll see that the connection between excel and sql on the field Item_no works. Regards, Damjan
You need to open the Data Menu / Dynamic Data Manager
Now select your SQL Table in the left part of the dialog
On the right side select Filter and Enable it.
Select which field you want (Item_no in your case)
And select the compare sign =
And on the right side select the Excel field called Item_no
I have a sample for you. But first you'll need to create on your local SQL Express server (if you have one) a database called TEST and in that database a table called Test1.
Code: Select all
CREATE TABLE [dbo].[Test1](
[Item_no] [int] NULL,
[Description] [nchar](50) NULL,
[Qty] [int] NULL
) ON [PRIMARY]
GO
Open the sample and you'll see that the connection between excel and sql on the field Item_no works. Regards, Damjan