Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data Wizard
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data Wizard
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) "John L" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data Wizard
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 "Sheeloo" wrote: 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) "John L" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data Wizard
I pasted your data into a txt file
see http://wikisend.com/download/438904/test.txt then opened it into Excel 2003 and got this http://wikisend.com/download/440944/test.xls data from worksheet copied below 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 -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "John L" wrote: 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 "Sheeloo" wrote: 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) "John L" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data Wizard
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 "Sheeloo" wrote: I pasted your data into a txt file see http://wikisend.com/download/438904/test.txt then opened it into Excel 2003 and got this http://wikisend.com/download/440944/test.xls data from worksheet copied below 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 -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "John L" wrote: 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 "Sheeloo" wrote: 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) "John L" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data Wizard
I am :-)
How do you 'import' from an Excel sheet? Can you pl. describe the steps you are following to do this? "John L" wrote: 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 "Sheeloo" wrote: I pasted your data into a txt file see http://wikisend.com/download/438904/test.txt then opened it into Excel 2003 and got this http://wikisend.com/download/440944/test.xls data from worksheet copied below 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 -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "John L" wrote: 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 "Sheeloo" wrote: 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) "John L" wrote: 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Importing Data Wizard
Glad you are happy
Toolbar Data Import External Data Import Data Select Source(your xl workbook) Select Table Ok Thanks Again John "Sheeloo" wrote: I am :-) How do you 'import' from an Excel sheet? Can you pl. describe the steps you are following to do this? "John L" wrote: 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 "Sheeloo" wrote: I pasted your data into a txt file see http://wikisend.com/download/438904/test.txt then opened it into Excel 2003 and got this http://wikisend.com/download/440944/test.xls data from worksheet copied below 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 -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "John L" wrote: 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 "Sheeloo" wrote: 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) "John L" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
New Data Query Wizard | New Users to Excel | |||
Importing data with Text Wizard | Excel Discussion (Misc queries) | |||
Chart Wizard Data Source | Charts and Charting in Excel | |||
importing data from the query wizard | Excel Discussion (Misc queries) |