Settings format

I want to create a file in which the settings of the file are not affected by the user filing the file or to be affected by the settings on his or her pc. I will use this file as input to a data base.
Any idea . the file is in EXcel and then converted(saved) as CSV Thanks

Hi @nataliejohnsons

Not sure I’m totally following what you are asking for. There is a PowerShell module for dealing with Excel files. Might be easier to use the module to render the Excel file as a PSObject and then load the DB. This would save the step of converting to a CSV file.

If I’m dealing with logical records where the total record can easily fit into memory, my preference is to keep the data in a XML file. It’s pretty hard to beat the performance of an in-memory DB. Less complex too, no DB software to install and manage too.