LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default data import question

I am trying to import data from an excel file into another excel file. The
data contains "+" and "0" values.

see sample of pre import data.
1 7011 4/14/2006 A2993 + + 0 +
2 7011 4/14/2006 B4253 + + 0 0
3 7011 4/14/2006 C3505 + 0 + +
4 7011 4/14/2006 D765 + 0 + 0

it imports as the following:
1 7011 4/14/2006 A2993
2 7011 4/14/2006 B4253 0
3 7011 4/14/2006 C3505 0 +
4 7011 4/14/2006 D765 0 + 0

why does the import delete the "0" in one column and the + in the other
column and not allow both to be imported as the original file?????
--
dr chuck
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Import Question Steve Haack Excel Discussion (Misc queries) 2 May 20th 09 10:37 PM
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Excel 2007 Import data question Stevens Setting up and Configuration of Excel 0 December 11th 07 09:22 PM
Data import/extraction question tempacc Excel Programming 1 June 18th 05 07:29 AM
import external data via macro/vba question Drabbacs Excel Programming 1 May 24th 04 11:36 PM


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"