Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Sorting Imported sql data

I have imported data from a sql table, when I try and sort a selection of data brought into excel it is automatically taking all the data and not just the selection. The tick for my data has headers is automatically on and greyed out.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

Are you sure you imported the data or did you create a link to sql. If it is a link then it will not allow you to work with a subset of the data because it would effect the data on the sql database.

Posted on Apr 13, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Excel Corruption files


Without seeing the file, it is difficult to diagnose what is going on, but I will offer some ideas.

What version of Excel are you using? Are you using Excel 2003? Was the file you are trying to open created in Excel 2007 or Excel 2010. If so, it might be using the new format and therefore will not open in Excel 2003 and older.

It is possible the Excel file is data that was imported from a source in which Excel cannot import. Does the Excel spreadsheet contain any imported data?
Try to use: XLSX Viewer Tool here : http://www.xlsx.viewertool.com/
Those are the most likely causes of the corrupt data. Is every file you open in Excel corrupt, or just this one workbook? If it is just this one workbook, then, yes, it sounds like it is corrupted. If every file you open with Excel is corrupt, then your version of Excel could be corrupt, but that is unlikely.

Jul 10, 2015 | Microsoft Excel for PC

3 Answers

Forgot SQL Server SA password. How to reset user password to login SQL Server?


When SA password for SQL Server logon forgot, please take SQL Password Genius to install it on computer.

Step 1: Run SQL Password Genius full version and browse Master.mdf file to import into it.

Step 2: Select SA user and click "Reset" button.
After master database file imported into SQL Password Genius, you would see all user in list. SA password is unknown. Select SA account and click "Reset" button.

A new window would pop up, type new password for SA account in it. And click "OK". Instantly, SA password is changed successfully. SA password lists in software screen.

Step 3: Close SQL Password Genius and restart SQL Server Services.

SQL Server services influence SQL password reset on computer. So we stop it before using SQL Password Genius. Now, when you finish SQL SA password reset, restart SQL Server Services to run SQL Server with SA account.

How to Reset SA and Other User Passwords for SQL Server

Jun 27, 2014 | Microsoft SQL Server 2005 Enterprise...

1 Answer

When using excel how to get dates to automaticly update in order


Sort the data to represent descending order for a chronological data set. If your information is listed in a table format in multiple columns, make sure you select all of the data and sort on the date field.

Feb 16, 2014 | Microsoft Excel Business & Productivity...

2 Answers

How to automatically import data from tally to excel. Want to display auto imported data in sharepoint.


Import TALLY Data / Export TALLY Data
Tally allows users to Import data from other software's as well as Export data from Tally to other software's. Tally allows users to Import and Export in ASCII, SDF and XML formats. XML is now the most widely used format of exporting data in the world. Any transactions can be exported from Tally and imported in other software after suitably altering the current structures to accept Tally data structure. The reverse is also possible by writing a small TDL program to accept the data from other software's. The data that is to be imported into Tally can be in either XML or DBF format. Easy Tally data transfer or Tally data migration from Tally 4.5 & Tally 5.4 to Tally 6.3 , Tally 7.2 , etc.
ODBC COMPLIANCE ALLOWS OTHER PROGRAMS TO USE DATA FROM TALLY DIRECTLY. E.G. : MS-EXCEL :
ODBC - OPEN DATABASE CONNECTIVITY
Tally is now ODBC compliant. Hence, any program like MS-Excel, Oracle etc that is ODBC compliant can use data from Tally. Here, data connectivity is dynamic i.e. any new updation in Tally is reflected in other ODBC Compliant Software immediately. Now, with ODBC facility the user can extract data out of Tally and design his own report formats in other ODBC compliant software's.
Procedure :
Now, Load Company -> specify period -> minimize Tally -> Open a new Excel file -> select data -> select 'Get External Data' -> select New database query -> choose Data Source
Tally connects to data source and displays Tally Wizard query screen -> select the columns you would want to include in the query.
Once all the columns are selected, the user returns to excel and excel displays all the columns selected
Graphical Analysis of Tally Data
Sometimes, pictures can say better than figures. Tally also provides graphical (Bar graph) analysis of data. The user can do a graphical analysis reports like Sales register, Purchase register, Ledgers, Funds flow, Cash flow, Item registers etc. This helps the user in deeper analysis of data. In Tally, a graphical analysis can also show month wise graphs for the year in comparison with any other period. This will help the management in quickly locating the highs and lean periods in a financial year and hence be better prepared for difficult times.
Web Enabled
Tally ees 6.3 is now Web enabled. This will help the user in reducing his paper work further. Now, report in Tally can be e-mailed directly from Tally. It is not just reports, but even invoices and purchase orders can also be e-mailed directly from Tally. Hence, the user does not have to send printed invoice or purchase orders from Tally.
Procedure :
Select any report (e.g. Balance sheet) -> select Alt+M (E-mail) -> specify all details as required by Tally
Ability to Publish Reports and Documents on the Internet
Now, Tally allows users to upload reports on the web site directly from Tally. So companies that would want to publish reports on the web site can do so directly from Tally. Many companies would also like to publish their price list on their websites along with the product they deal with.
Procedure :
Select any report (Profit and Loss A/C) -> select Upload (Alt + O) -> specify all details as required by Tally.
Direct Internet Access
Tally now offers direct Internet access. A Tally user while working on Tally can directly log on to tally website get details of all the facilities offered by Tally. The user can also download the latest releases of Tally 6.3 as and when available. Tally website also offers a facility of Tally Chat. Any user can now chat with a Tally representative and get any information regarding Tally.
Procedure :
Start Tally -> now, from any screen select Web Browser (Alt+W). Tally now takes you to the Tally Web site.
Print Preview
Any user would ideally like to view format of reports / Invoices / Vouchers before printing the same. Tally now offers a facility of print preview. Now any report can be viewed before printing or before it is mailed. Once Tally shows the preview the user can either opt to print or mail the same.

Apr 15, 2010 | Microsoft Office Excel 2007

1 Answer

Excel 2007 question


Ok, I realized that I wasn't paying attention when I created my test spreadsheet. My first cell wasn't sorting properly because it started with a ";" instead of a letter, so it always stayed at the top. I removed the extra character and repalced it with another letter, tried it again and it worked. If there's only 1 column, it doesn't ask to expand the selection. If there are nearby data cells, it asks you what you want to do. I was able to get it to work every time by selecting "Continue with existing selection" instead of "Expand selection".

May 14, 2009 | Microsoft Office Excel 2007

2 Answers

Import data to excelsheet insert in mysqltable query


You can save it as csv and use the file to insert using
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);

Feb 20, 2009 | Microsoft Office Standard 2007: Windows

2 Answers

Steps in saving file in excel to database


severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

1 Answer

CSV file to Import correctly into Excel 2003


Rudils,

The key is to import the data and not open the file directly.

1. Open a Blank Workbook in Excel.
2. Data, Get External Data, Import Data. (Excel 2007 is Data, Get External Data, Data from Text)
3. Browse to your .csv file and Select "Import".
4. Import Wizard should appear.
5. Page 1 Select "Delimited"
6. Select the row which you want to start the import.
7. click "Next"
8. In the Delimiters, select "semicolon" and/or other delimiters you are using.
Note: The bottom half of the window will preview the way the data is to be imported.
9. click "Next"
10. highlight each column of your data in the window below. For each column you can specify "General", "Text", "Data", or "do not import column" using the radio buttons in the top left of the Wizard box. This is an optional step.
11. Click Finish.

I hope that helps. Please add a comment if it not clear.

kpenguin

Nov 22, 2007 | Microsoft Excel for PC

1 Answer

Help me....


You have to creat a table in the SQL server db then you can

 

a) use some windows host script or vb to read your data and insert into the db..

 

b)you can also use the acess:

0695665.jpg

Oct 13, 2007 | Microsoft SQL Server Standard Edition for...

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

118 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...