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

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How do I get my gmail contacts transfered to my Microsoft Outlook 7 contacts?


OK
try these steps:

  1. Log on to your Google Gmail account.
  2. In the left column, click Contacts.
  3. On the right side of your screen, above the message count, click Export.
  4. Click Outlook CSV (for import into Outlook clients).
  5. Click Export Contacts.
  6. When prompted to download the export file, click Save.
  7. Choose a location on your computer to temporarily save the file. The default file name is gmail-to-outlook.csv.
NOTE You can delete this file after your contacts are imported into Outlook.
  1. Click Save.
  2. In Outlook, on the File menu, click Import and Export.
  3. Click Import from another program or file, and then click Next.
  4. Click Comma Separated Values (DOS), and then click Next.
  5. In the Import a File box, browse to find the file you downloaded in step 8, and then double-click the file.
  6. Click one of the following:
    • Replace duplicates with items imported
    • Allow duplicates to be created
    • Do not import duplicate items
  7. Click Next.
  8. In the folder list, click the Contacts folder where you want the imported contact information to go, and then click Next.
  9. To add or remove fields to determine the way the contact information is saved in the new imported file, clickMap Custom Fields.

Thanks to:
Microsoft at:
http://office.microsoft.com/en-us/outlook-help/transfer-contacts-between-outlook-and-google-gmail-HA010222048.aspx

Jul 07, 2014 | Microsoft Office Outlook 2007: Windows

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

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

1 Answer

Dear Sir, In case there are atleast 80 files or more having same format containing datas in columns in each file with different figures, I want to merge all file in a single sheet in one shot. Kindly...


Hi,

If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.

Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.

Then finally, export/save as that external sheet to any filename of your choice.

Hope this helps.

Thanks.

Mar 24, 2009 | Microsoft Excel for PC

1 Answer

Importing Excel file into Act 2006 Version8


My advice is not specific to Sage, but exoprting Excel data.

Check there are no missing/ blank cells within the range, anything that is blank change it to 0.

Make sure the format of your range matches the character length allowed in Sage - Especially for text - if necessary check the no of characters using =LEN(B2) - Assuming B2 contains the text you are checking, where necessary trim the no of characters.

Change your format to CSV if possible, sometimes easier to import.

If you do the above and receive an error message or can narrow down the issue it will give me a better idea of why the import is failing.

Mar 23, 2009 | Sage ACT! 2006 Full Version for PC

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

1 Answer

Converting IIF files from Quick Books Pro 2005 to CSV


Means converting IIF to CSV. Have the IIF, need it in CSV format. Can anyone propose a tool?

Jan 14, 2009 | Intuit QuickBooks: Pro 2005 for PC

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

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

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

Not finding what you are looking for?
Microsoft Excel for PC Logo

126 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...