Database Tag Directory

Featured Database Questions

  • Creating an Access 2007 query with results similiar to a Crosstab query

    I am new to Access and I have an Access 2007 database that has a table that has the following fields: Employee Name, Date Worked, Yes/No for Paperwork Received and Yes/No for Paperwork Returned. Is it possible to create a query that I can run a report off of that will show one row for each...

    mjp126215 pointsBadges:
  • SAP – Create CSV from Text format

    I tried to convert the text format to CSV format by USing internal table and the FM isSAP_CONVERT_TO_CSV_FORMAT. But wn i download to CSV format the file contains fields serepared by ';'.So becuse of this Im unable to Up load this file.

    822370 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:
  • Errors creating database with SQL Server 2008 I&M Training Manual

    I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),...

    Howhighthemoon20 pointsBadges:
  • How to match CSV field values in SQL Server 2005

    i have an table in sql-server 2005, in which my one field is storing csv values.Suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in csv format. now my problem...

    Sanjeevgoyal5 pointsBadges:
  • How to convert SQL Server 2008 R2 BPA output into CSV?

    I have been using SQL server 2018 R2 BPA for getting data from Microsoft. When using SQL Server 2005 to export results I could do so in a CSV format. When we upgraded two servers to Server 2008 I found that I could no longer run BPA 2005 on these. We then upgraded to 2008 R2, which again does not...

    ITKE343,740 pointsBadges:
  • Script to extract files information from FTP server

    Hi, I wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will: Log on to a ftp server using a generic account and password It then find the files (no downloading) in a specific folder that begins with...

    Aiko2720 pointsBadges:
  • Import AD data from CSV file to 2003 ad

    We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.

    Karl Gechlik9,860 pointsBadges:
  • Is it possible to Upload indexed records to DMS system in SAP?

    Hello Experts, I have two queries: Is it possible to Upload indexed records to DMS system in SAP? And also our client has have provided us with an indexing solution for the scanned records in CSV format. Is there a way we can use this solution to upload the records in  SAP. Thanks, Bharath

    bsr57110 pointsBadges:
  • Collation

    What is simple definition and example of collation?

    Raviknowledge5 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:
  • How to create a CSV file in PHP code?

    I need to create a physical CSV file from PHP code. I have many solutions to get the results to print to a screen, but I need a file... any ideas?

    Texmansru4725 pointsBadges:
  • Data warehouse vs Database

    What is the difference between a database and a data warehouse?

    Gayle5 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 pointsBadges:
  • How to know whether the CSV extraction to PF happened today

    I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the 2 program and have to check in the...

    RamvishakRamesh2,505 pointsBadges:
  • Take .csv files and show that on a subfile

    Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option - upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with a 'U' to upload and the...

    RamvishakRamesh2,505 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:
  • Corrupted database file with Memo Field in FoxPro 2.6

    I am using a software in foxpro 2.6 i had a problem that a database file with memo field has been crupted i have used foxbase for repairing but that file is not opening i have erased cdx file bofore using but that file still not openig kindly solve this problem

    Asifarp5 pointsBadges:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following