Importing csv data (not with standard action)

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
jan1111
Newcomer
Posts: 2
Joined: Wed May 14, 2014 12:47 pm

Importing csv data (not with standard action)

Post by jan1111 » Mon Jan 04, 2021 3:37 pm

Hi,

I am looking for a routine to import a csv file in a NiceLabel connected database, like Accessfile.
The standard ‘Import Data into Tabel’ NiceLabel action is prompting for a folder/file, I want to avoid the prompting.

Does anybody has a hint for me? Can't find it in SQL. I guess it's gonna end up with VBscript??

Kind regards,
Jan van der Wiel
Geostick BV

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

Re: Importing csv data (not with standard action)

Post by Kyleodonnell » Thu Jan 07, 2021 2:53 pm

Jan1111

you can use SQL through VB, you would need to use a form timer or a button to do the import.

jan1111
Newcomer
Posts: 2
Joined: Wed May 14, 2014 12:47 pm

Re: Importing csv data (not with standard action)

Post by jan1111 » Mon Jan 11, 2021 5:00 pm

Hi Kyle,

Thanks. Would be a button.
But I am really curious after the SQL code t do the import.

Regard,
Jan

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

Re: Importing csv data (not with standard action)

Post by Kyleodonnell » Tue Jan 12, 2021 2:57 pm

Jan1111,

Would be a simple insert statement, we recommend using something like powerforms or automation as those have built in SQL actions where you would not need to use VB in order to accomplish it

Post Reply