dbp export
Quote from s7shanbe on December 31, 2019, 8:53 pmhello everyone
How to write a dbpexporttocsv command to have each field stored in its own column?
And is it possible to send data to an Excel file?thank you
hello everyone
How to write a dbpexporttocsv command to have each field stored in its own column?
And is it possible to send data to an Excel file?
thank you
Quote from Gaev on January 1, 2020, 4:42 am@s7shanbe
How to write a dbpexporttocsv command to have each field stored in its own column?
Here is the Help file information about the command.
https://neodbprohelp.visualneo.com/ImportExport.html#dbpExportToCSV
- the content of each database record will be stored in a separate line (within the Text file, that you can view using noepad.exe or any other Text Editor program)
- within each line, the content of each column will be separated by a comma
... what is it about the command that you need help with ?
And is it possible to send data to an Excel file?
You can load the contents of the exported file into any program that accepts csv-format files (Excel is one of them).
@s7shanbe
How to write a dbpexporttocsv command to have each field stored in its own column?
Here is the Help file information about the command.
https://neodbprohelp.visualneo.com/ImportExport.html#dbpExportToCSV
- the content of each database record will be stored in a separate line (within the Text file, that you can view using noepad.exe or any other Text Editor program)
- within each line, the content of each column will be separated by a comma
... what is it about the command that you need help with ?
And is it possible to send data to an Excel file?
You can load the contents of the exported file into any program that accepts csv-format files (Excel is one of them).
Quote from s7shanbe on January 1, 2020, 2:44 pm@gaev thank you.
The problem is that all the information is stored inside a cell in each row
Can each field's data be stored in a separate cell in Excel?
@gaev thank you.
The problem is that all the information is stored inside a cell in each row
Can each field's data be stored in a separate cell in Excel?
Quote from Gaev on January 2, 2020, 4:45 am@s7shanbe
Here are links to a couple of YouTube videos that show you how to import/load the data so that each field is in a separate column ...
https://www.youtube.com/watch?v=KnugjDii3Ws
https://www.youtube.com/watch?v=m4n7FwDH2JsIf you are still having difficulty, time to check if you are generating the csv data correctly ... please post ...
1) the exact parameter values used with the dbpExportToCSV command (if you are using variables, best to temporarily replace them with hard coded values so it is clear what parameter values are being specified)
2) open the resulting csv file using notepad.exe (or your favourite text editor) ... then, copy the contents of this file (just the first two or three records/lines will do) and post them here
Here are links to a couple of YouTube videos that show you how to import/load the data so that each field is in a separate column ...
If you are still having difficulty, time to check if you are generating the csv data correctly ... please post ...
1) the exact parameter values used with the dbpExportToCSV command (if you are using variables, best to temporarily replace them with hard coded values so it is clear what parameter values are being specified)
2) open the resulting csv file using notepad.exe (or your favourite text editor) ... then, copy the contents of this file (just the first two or three records/lines will do) and post them here
Quote from alangonzalez91 on January 3, 2020, 1:01 amCSV to XLS
https://archive.visualneo.com/viewtopic.php?f=22&t=21833
CSV to XLS
Quote from Gaev on January 7, 2020, 7:09 pm@s7shanbe
Here is a post from the old NeoBook Forum ...
https://archive.visualneo.com/viewtopic.php?f=21&t=17189&p=11221599&hilit=odbc+Excel#p11221599
... which talks about the ability to treat an xls file as database ... which should allow you to read/write directly to such files from within your Application (using neoDBpro commands) ... no need to export/import to csv files.
Here is a post from the old NeoBook Forum ...
https://archive.visualneo.com/viewtopic.php?f=21&t=17189&p=11221599&hilit=odbc+Excel#p11221599
... which talks about the ability to treat an xls file as database ... which should allow you to read/write directly to such files from within your Application (using neoDBpro commands) ... no need to export/import to csv files.