Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • Script to upload to eBay without being on their site?

    Question. I'm interested to know if there's a way to write some script to upload a listing to ebay (whether from something like a CSV, Excel etc or any other format) without actually doing it through the File Exchange on the ebay site or using the standard listing procedure. Any ideas / suggestions...

    pluxmania5 pointsBadges:
  • How to save a Microsoft Excel file to CSV

    I've been having a ton of issues saving my Microsoft Excel file to CSV. When I'm saving it, many of the characters change from dash to a question mark. Why would this be happening? Do I have to do some encoding changes? Thanks so much.

    ITKE1,050,915 pointsBadges:
  • 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.

    ITKE1,050,915 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

    ITKE1,050,915 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...

    ITKE1,050,915 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!

    ITKE1,050,915 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!

    ITKE1,050,915 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!

    ITKE1,050,915 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.

    ITKE1,050,915 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?

    ITKE1,050,915 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.

    ITKE1,050,915 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.

    ITKE1,050,915 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?

    ITKE1,050,915 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?

    ITKE1,050,915 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...

    ITKE1,050,915 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:

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