Write to database

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
crazytok
Newcomer
Posts: 2
Joined: Tue Jan 19, 2021 9:26 am

Write to database

Post by crazytok » Tue Jan 19, 2021 9:33 am

Hi,

I have searched but cant find anything about writing data to excel.

I would like to have Nicelabel to write my serial nr counter text field, into a specific excel field.

Is that possible? I only find how to read from excel... :/

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 720
Joined: Mon Aug 28, 2017 3:07 pm

Re: Write to database

Post by Kyleodonnell » Fri Jan 22, 2021 2:42 pm

Crazytok

Writing to excel would take a complex amount of scripting in order to do, as excel is not a database, its a formatted spreadsheet. We recommend using Access or SQL and you can use SQL statements to write to the database.

crazytok
Newcomer
Posts: 2
Joined: Tue Jan 19, 2021 9:26 am

Re: Write to database

Post by crazytok » Sat Jan 23, 2021 8:41 am

Aha is that so... I thought nicelabel had support for excel in both reading and writing direction!

Im not familar with either Access or SQL, is there any guide how to setup and link nicelabel with access and make nicelabel write my serials to access?

Or do you recommend doing the opposite instead? Having access to create my serials and then using nicelabel to read from it?

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 720
Joined: Mon Aug 28, 2017 3:07 pm

Re: Write to database

Post by Kyleodonnell » Mon Jan 25, 2021 6:02 pm

Crazytok,

linking to to access is fairly easy, you just have to follow the wizard in the software

You would need to do insert statements on a powerforms solution you can find more about SQL here
https://www.w3schools.com/sql/sql_insert.asp

Post Reply