Exporting records to individual files (Base or Calc)

classic Classic list List threaded Threaded
2 messages Options
GJim GJim
Reply | Threaded
Open this post in threaded view
|

Exporting records to individual files (Base or Calc)

I have 1600+ records (rows) where I wish to export each to an individual external file.  

Export the information in Column B and save the file as the name in Column A.

I'm comfortable with SQL code for Base, or Macro for Calc.

Just need to have some idea of the coding.

Thanks,
G-Jim
Dave Howorth Dave Howorth
Reply | Threaded
Open this post in threaded view
|

Re: Exporting records to individual files (Base or Calc)

On Thu, 23 Feb 2017 09:41:49 -0700 (MST)
GJim <[hidden email]> wrote:

> I have 1600+ records (rows) where I wish to export each to an
> individual external file.  
>
> Export the information in Column B and save the file as the name in
> Column A.
>
> I'm comfortable with SQL code for Base, or Macro for Calc.
>
> Just need to have some idea of the coding.

Maybe save the information as a CSV file and use whatever scripting
language you are most comfortable with?

> Thanks,
> G-Jim
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Exporting-records-to-individual-files-Base-or-Calc-tp4208796.html
> Sent from the Users mailing list archive at Nabble.com.
>


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted