Importing Data Wizard

J

John L

Gday All,I have searched your great disscusion group but cannot find a answer
to this question .When I use the Import data wizard some data does not come
,it appears that if the a column has mainly numbers and a with a few cells
with only text in them the text will not import and vice versa,I need all the
data ,I could link the sheets but would rather not, I can use VB if needed.
Can some one please help.John
 
S

Sheeloo

Excel does NOT skip values while importing... If you have delimited data then
your text file might be missing some fields in certain rows...

Can you paste a few sample rows of data here? Or upload the file at
wikisend.com and paste the link here (assuming, of course, there is nothing
confidential)
 
J

John L

Thanks this is a very simple few columns of data and as you see it does miss
some data ,unfortunatley the data format in the source sheet cannot be
changed,I am using 2003 on both workbooksSource data

Name 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 5-Feb
John1 34 23 46 47 48 49
John2 al al 49 49 49
John3
John4
John5

Imported Data
F1 F2 F3 F4 F5 F6 F7
Name 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 5-Feb
John1 34 23 46 47 48 49
John2 49 49 49
John3
John4
John5
 
J

John L

Sorry I did not put in a importent point, I am trying to import from a excel
sheet to a excel sheet not from a txt file,keep thinking please
John
 
S

Sheeloo

I am :)
How do you 'import' from an Excel sheet? Can you pl. describe the steps you
are following to do this?
 
J

John L

Glad you are happy

Toolbar
Data
Import External Data
Import Data
Select Source(your xl workbook)
Select Table
Ok
Thanks Again John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top