Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • Loading CSV file into PostgreSQL table

    I have a CSV file that's set up like this: value1|value2|value2.... How would I be able to load these into my PostgreSQL table? Appreciate the help.

    ITKE827,935 pointsBadges:
  • Is there a way to validate a CSV string in .NET?

    Hi experts, Does anyone know if there's a way for me in .NET that would validate my CSV string? Is there something in C# that would help? Thanks, Doug

    ITKE827,935 pointsBadges:
  • How to show progress of CSV file to MySQL upload

    My CSV file is very large (Millions of files) and I'm currently loading it into MySQL. I'm using the LOAD DATA INFILE command. But I feel that this is taking way too long. Is there a way for me to see the progress of the upload? I tried SELECT COUNT(*) but it keeps giving me a 0 count. What should...

    ITKE827,935 pointsBadges:
  • How to convert Microsoft Excel spreadsheet to CSV programmatically

    Does anyone know of an easy way (possibly a Unix script or command) to convert my Microsoft Excel spreadsheet to CSV? Thank you very much!

    ITKE827,935 pointsBadges:
  • Convert CSV string in ASP.NET

    For ASP.NET - can I convert a CSV string into a string[] or possibly a list? In the data - there are no commas if that makes it easier. Thank you!

    ITKE827,935 pointsBadges:
  • Write output of Fortran program in CSV format

    Sorry if this question is confusing but I have a Fortran program and I need to write the output in a CSV format. That way - I can open the file in Excel to plot my data. Thanks!

    ITKE827,935 pointsBadges:
  • Converting JSON file to CSV file using Ruby

    My teammate in my department needs to convert our JSON file to a CSV file using Ruby. What's the best way to do that? Thanks very much.

    ITKE827,935 pointsBadges:
  • CSV format isn’t opening up correctly in Internet Explorer

    I currently have a JSON object that's turned into an array, followed by a CSV format (file). For Internet Explorer - it keeps opening up a new window. I don't want that. I need the file to download or have the 'save file' window to appear. Anyone know why this is happening?

    ITKE827,935 pointsBadges:
  • Export in db2 iseries

    i want to export query output to a csv file on iseries ..can anyone tell me how to do that

    Hn25 pointsBadges:
  • Export MongoDB records to CSV

    Could I possibly export my MongoDB records to a CSV file? I've tried this code: mongoexport --host localhost --db dbname --collection name --csv > test.csv But it keeps telling me to specify the fields that I want to export. Can I just export everything (not specify which fields)? Thank you.

    ITKE827,935 pointsBadges:
  • Linux command line for CSV viewer

    Can anyone tell me if there's a Linux command line CSV viewer? I tried Excel and OpenOffice but I just need to look at the data (not make any changes). Also - it needs to have vertical / horizontal viewing too.

    ITKE827,935 pointsBadges:
  • Export Oracle SQL Developer query to CSV file

    I'm currently using Oracle SQL Developer and I need to export one of my queries to a text file. I would like it to be a CSV file. But I'm not seeing any export options at all. Even double clicking on the query itself didn't work. What should I do here?

    ITKE827,935 pointsBadges:
  • Download a CSV app

    How can I download a csv. app?

    frharrison5 pointsBadges:
  • How to convert Excel file to CSV

    I currently have a Microsoft Excel that has characters in different languages. I have to convert it to a CSV file. But when I'm trying to save it, those characters are destroyed (FYI - those characters aren't ASCII characters). How can I go about doing this? Should I use UTF-8?

    ITKE827,935 pointsBadges:
  • How to open .tra file in R?

    I am trying to work with a .tra file in R studio. But I'm unable to open it. Can someone tell me how to open it or suggest me a code to convert it to a csv file?

    niveditha5 pointsBadges:
  • Run SQL query with CSV format

    I'm trying to run a SQL query from my Linux command line and getting the result in a CSV format. Here's what I have so far: mysql -u uid -ppwd -D dbname << EOQ | sed -e 's/ /,/g' | tee list.csv select id, concat("\"",name,"\"") as name from students EOQ And here's my issue: The columns that...

    ITKE827,935 pointsBadges:
  • Access database file corrupt

    i am using acces database but something is happened, my database file is not working properly pls if you have any idea about this problem pls let me know or specific mail me on my e-mail id anteshwar.bhosale123@gmail.com thanks anteshwar bhosale

    192168020120 pointsBadges:
  • How To create an CSV file in Mainframe (from Object star database)?

    I have to create some extract from Object star tables, in CSV format.Please let me know if any utility or programe can be used.

    Ari200940 pointsBadges:
  • Corrupted log file on Exchange still needs to be restored.

    How would you recover Exchange server when the log file is corrupted?

    Karl Gechlik9,860 pointsBadges:
  • conversion problem

    how do you convert DCF files into CSV files for export to Excel Spreadsheet

    ironpony45 pointsBadges:

Browse Alphabetically:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following