1
  • Retrieving missing Excel data

    I had an excel file with 10 worksheets on it. I opened the file yesterday and found the whole 10 worksheets missing from the file. What could have caused it and is there a way to retrieve this data back to the file?

    Tess695 pointsBadges:
  • Excel and Works databases both stop responding

    I have an HP Pavilion Laptop running Vista :(   - I've begun having continual problems with databases locking up and not working.  Have Excel 2010. When working with data, the circle spins and then says Excel not responding.  Switched to Works database ... was fine for one day, used it again...

    EntExp5 pointsBadges:
  • Transaction web page using MS Excel

    How to develop transaction web page using MS Excel as database?

    ramki19805 pointsBadges:
  • Is there a standard formula for counting highlighted cells in Excel 2007?

    Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same...

    Buddyboy12310 pointsBadges:
  • Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows

    How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?

    MLM10 pointsBadges:
  • Performance files to Excel

    I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks

    DudleyShaw15 pointsBadges:
  • generating a custom database from an existing database

    from a excel database with say 300 names, I would like to click a button to choose the names and quantities to generate a custom vdp database.

    LVNEONCOWBOY211215 pointsBadges:
  • Using Excel 2010 to pull data from SQL Server?

    How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

    NewnanIT1,110 pointsBadges:
  • Matching data in Excel

    Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to match the S/N from spreadsheet 1 with spreadsheet...

    Aslan5 pointsBadges:
  • Excel date format

    I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

    Tamara5 pointsBadges:
  • Importing large sets of Excel 2000 data to SQL database

    I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

    ITKE350,845 pointsBadges:
  • Exporting large files from FoxPro 6.0 to excel

    I asked about exporting large files from fox pro 6.0 to excel because my computer was cutting off large data base i am trying to export. This is the answer you gave me: Excel is stopping at 16k records.  As a workaround, export to CSV format; you can then use a text editor (e.g., Wordpad) to split...

    0 pointsBadges:
  • Excel as a front end to sql, data integrity

    how do I put a value in a sql field that will not be counted in a excel pivot table? I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables. The field I am interested in has either a text value or a NULL: CaseID (varchar (15), null). When I pull...

    Dannl10 pointsBadges:
  • Crystal Reports 11 problem with excel spreadsheet

    I AM USING AN EXCEL SPREADSHEET AS MY DATABASE. ON THE SPREADSHEET I HAVE A COLUMN THAT HAS NUMERIC AND ALPHA VALUES. WHEN A ADD THIS TO THE CRYSTAL REPORT ONLY THE NUMERIC VALUES DISPLAY AND THE FIELD CANOT BE FORMATTED AS ANYTHING OTHER THEN A NUMBER FIELD. ON THE EXCEL SPREADSHEET THE COLUMN IS...

    SATELE015 pointsBadges:
  • Automatically populate a form based on a match from another worksheet.

    Ok, here goes... I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a 'Talent Profile' form (also created in Excel) that I give to HR whenever...

    Jedski2520 pointsBadges:
1

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