Question about Microsoft Excel for PC

1 Answer

Importing csc files

Hi, i got a problem importing csv files to exel 2003, i use the import wizard as recommended, the data show up but some columns are shown in date format, although everything is set to standard format. during the import it looks like low numbers show up in date format, all other do well.
thanks for your help.

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 52 Answers

Hi freaks11,
I am DennisGladx and I hope to assist you.

This sounds like the Column of the data you want should be changed when you import the text file.
Right click on the column letter,
Left click on format cells from the drop down list and select the cell Con-tense you want to display.

Glad to be of assistance
please rate the solution - I can learn from your rating - Thanks

Posted on Oct 29, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Import CVS contact list WRONG FORMAT?


Go back to the instructions for the CSV import and make sure you have only the specified columns in your CSV file and that the column headers (row 1) are exactly as described. There are usually no spaces in column headers and some are case (capitalization) sensitive.

Sep 29, 2017 | Contact Computers & Internet

1 Answer

Trying to import csv file.


Try opening the csv file in a text editor like Notepad++ and see if there are any special characters present in the file that might normally be invisible. There is a setting to see special characters (View > Show Symbol > Show all characters).

It looks like you might have additional carriage return or linefeed characters. You could try exporting your records again and see if the csv's match.

Apr 28, 2012 | Dmitri Karshakevich E-Z Contact Book

1 Answer

Please transfer old account,joeybanta1113@hotmail.com,to new account,joeypanetta2011@gmail.com i need all my contactacks! and my pictures,"please help me"!!!! thank joey panetta


Exporting Hotmail ContactsThe first step is to get the information you need out of Hotmail, you can achieve this by doing the following:-
  1. Select Contacts from the Hotmail navigation bar.
  2. Click On Print View.
  3. Highlight the entire contents of the table (including the heading names e.g. Name, E-Mail and Phone as well as all your contacts).
  4. Press Ctrl+C to copy the table.
  5. Create a new spreadsheet document in Excel.
  6. Select Edit and then Paste from the main menu.
  7. Sort the data by the E-Mail column.
  8. For any rows with a blank E-Mail column copy any e-mail address from the Name column to theE-Mail column.
  9. Read this guide from Google on the format of CSV contact files and make any adjustments as may be necaserry.
  10. Select File and then Save As... from the menu.
  11. Make sure you select a format involving "CSV" for saving the file. (GMail can import csv files)
You should now have a csv file containing all your Hotmail contacts ready for importing into GMail.
Importing Your Hotmail Contacts Into GMailImporting your new contacts file into GMail is really straight forward:-
  1. Select Contacts from the GMail left hand menu.
  2. Select Import from the 3 options at the top right of your list of contacts.
  3. Click Browse to locate your csv file containing your Hotmail contacts.
  4. Click Import.

Jun 27, 2011 | Computers & Internet

2 Answers

How to convert the csv file into excel form?


When you choose to open the csv file - A pop up box will take you through the steps - You need to highlight the seperators as Excel is currently unable to do this.

Once you are going through the process you will be able to select, hash, space, comma as the seperataor into the respective columns.

Apr 27, 2009 | Microsoft Office Excel 2003 for PC

8 Answers

Can't import address book into Xerox Workcentre 7345.


The CSV format is below


"*",1,1,2,,
MFDN,MFADDRT,MFCN,MFIKEY,MFVDN,MFLINE,MFFAX,MFRBC,MFCMODE,MFSRESO,MFSHEET,MFSHEETC1,MFSHEETC2,MFPMAX,MFTMSND,MFTMSNDH,MFTMSNDM,MFMBOX,MFMBOXPS,MFMBOXID,MFRLY,MFRLYID,MFRLYPRN,MFRLYNUM,MFCHRGT1,MFCHRGT2,MFCHRGT3,MFFCODE,MFPCODE,MFSG3FRBT,MFMDMSPD,MFECMFRBT,MFEJBIGFRBT,MFIFAX,MFTIFF,MFIFAXCMODE,MFIFAXSRESO,MFIFAXPMAX,MFIFAXTMSND,MFIFAXTMSNDH,MFIFAXTMSNDM,MFSN,MFGN,MFMAIL,MFAUX1,MFAUX2,MFAUX3,MFSVRT,MFSVRADDR,MFPORT1,MFPORT2,MFUSER,MFPASSWD,MFVOLUME,MFPATH,MFUSETLS
0001,MAIL,Glenn,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Marsden,,glenn@*************.co.uk,,MAIN OFFICE,,,,,,,,,,

Mar 26, 2009 | Office Equipment & Supplies

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 Computers & Internet

1 Answer

Need to add employee e-mail address to xerox 440st so we don't have to type it in each tme



NOTE: Accessing the Public Address Book is optional. The Document Centre will accept a Public Address Book file that contains a list of user names and their E-mail addresses. This file must be Comma Separated Values (CSV) format for the device to be able to read the file contents. The majority of word processing packages will allow you to create a CSV file. A selection of e-mail applications will also allow you to export a list of users in the CSV file format.

The completed CSV file is imported to the device through CentreWare Internet Services. The file must have the .CSV file extension. A valid CSV file format includes the name and SMTP e-mail address. The CSV file should be created so that the Names are in one column and the E-mail addresses are in the next column. For example, the following are both valid format CSV file entries:

Smith, Smith@company.com
Smith, John - john.smith@company.com

The order in which entries are displayed in the Public Address Book at the Document Centre will depend on how the entries are sorted in the CSV file.

NOTE: This solution assumes Microsoft Internet Explorer is being used as the web browser. Other web browsers may vary. You may need to contact your System Administrator to perform this solution, as it requires knowledge of the network’s email system. Configuration of the LDAP directory settings requires the network to support LDAP Services.

The Document Centre will have to be configured for TCP/IP (IP Address, Subnet Mask, Broadcast Address, Gateway Address). Before you begin, print a Configuration Report and make sure the Document Centre has an IP address and the HTTP protocol is enabled.

From the workstation desktop:
  1. Click on [Start], point to [Programs], and select [Internet Explorer] to launch Internet Explorer.
  2. Click on [File] from the toolbar, then select [Open]. The Open window will be displayed.
  3. Enter the IP address for the Document Centre in the Address: field, then press [Enter] on your keyboard. CentreWare Internet Services window will be displayed.
  4. Click on [Index] in the upper, right corner of Internet Services. The Index window will be displayed with a list of hyperlinks to different areas of Internet Services.
  5. Click on [Public Address Book ] from the list of hyperlinks. The Public Address Book Settings window will be displayed.
  6. Click [Browse]. The Choose File window will be displayed.
  7. Browse to the location of your Address Book File (*.CSV).
  8. Highlight the CSV file and click on [Open]. The path for your .CSV file will be displayed in the Address Book File (*.CSV) field.
  9. Click on [Import Now]. An 'Are you sure you want to overwrite the existing Address Book? This cannot be undone' message may be displayed. Click [OK] to import the address book.

    NOTE: You cannot import a .CSV file with a blank name or e-mail field.

  10. An Enter Network Password window may be displayed. In the User Name: field, enter the system login of admin, in lower case letters. In the Password: field, enter the system password, then click [OK].

    NOTE: If you do not know the system password, contact your administrator. The initial system password at machine install is 1111 for the Document Centre 460|470|480|490, and 22222 for the Document Centre 425|430|432|440. If the administrator encounters a problem with changing or forgetting the machine password, a service call must be placed.

  11. Click on [Map Existing Address Book] to identify which headings in the CSV file contain the name and e-mail address to use in the Public Address Book.

    NOTE: If the CSV file contains names and e-mail addresses only, the file may map automatically.

  12. Click on the [Display Name] drop-down menu under the Imported heading. Select the heading that corresponds to the data you wish to use as the display name in the address book. The data you selected will be displayed in the Imported Sample field.
  13. Click on the [E-mail Address] drop-down menu. Select the heading that corresponds to the data you wish to use as the e-mail address in the address book. The data you selected will be displayed in the Imported Sample field.

    NOTE: If you are using a DC460|470|480|490, and if the CSV file does not contain a heading row, the drop-down menu will contain information from the first line of data in the file. For correct Public Address operation, the display name must map to a user name and the e-mail address must map to an SMTP format e-mail address, for example, name@domain.com.

    If you are using a DC425|430|432|440 and if your CSV file does not contain a heading row, the first row of data will be lost.

  14. Click on [Apply New Settings] to save any changes.

    NOTE: If you click on the [Clear All Addresses] button all entries will be removed from the current public address book.

  15. Click on the [X] in the upper, right corner to close Internet Explorer and return to the desktop.

Sep 23, 2008 | Xerox Office Equipment & Supplies

2 Answers

How to convert exel file to foxpro file


You can import the Foxpro file after you've used the DataConnection Wizard. You'll find this under the Data tab in Excel 2007 - under Get External Data section and click on From Other Sources

http://office.microsoft.com/en-us/excel/HP102017101033.aspx?pid=CH100648471033#Importing%20data%20by%20using%20the%20Data%20Connection%20Wizard

Aug 04, 2008 | Microsoft Excel for PC

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

2 Answers

CSV file to AS/400


FTP is "line oriented." It has no concept of 'database record formats.' It transfers strings of characters with essentially no knowledge of 'fields' or 'columns' that make up 'records.' A 'record' to FTP is usually just whatever string of characters that is found between record delimiters.

Trying to FTP into a DB2 externally-described database file requires having strings of characters that are (1) laid out to match the receiving record format and (2) either are already converted to the proper CCSID and transferred as BINARY, or are ASCII characters that would result in conversions to all the right characters and transferred as ASCII.

Regardless of which alternative is chosen for "(2)", the handling of record format positions that would match up with packed-decimal or other non-character type fields would be very tricky.

That's where a somewhat 'standard' file format such as .CSV comes in.

However, you don't transfer the .CSV file directly over the top of the DB2 file. Instead, you transfer the .CSV file into a simple directory on your AS/400 and then use it as the source for a DB2 import function. On your AS/400, the import function is most often the CPYFRMIMPF command.

The import takes the .CSV file and handles all of the mappings for field positions and data types.

As such, the sequence becomes (1) FTP the .CSV file to the AS/400, and (2) run CPYFRMIMPF on the AS/400.

Note that the format of the .CSV file makes a difference. You need to ensure proper CCSID settings, proper quoting where necessary, proper record separators, etc. Make sure that you generate a .CSV that can be converted to the record format of the eventual target database file. Lots of possible details, but _far_ easier than trying to construct a matching DB2 record format on a different platform.

Sep 19, 2007 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

127 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2888 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18408 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...