| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do a import data from a text file to an excel worksheet
I have more than 66,000 lines of data to import into excel (v.2003). Can I
do this without loosing data? -- mad ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a import data from a text file to an excel worksheet
xl2003 only has 65536 rows per worksheet.
You could use your favorite text editor and split the data into smaller pieces and then import each of the smaller pieces into separate worksheets. Probably not what you want, huh? madlin wrote: I have more than 66,000 lines of data to import into excel (v.2003). Can I do this without loosing data? -- mad ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a import data from a text file to an excel worksheet
I think the best way is to load your data in Access, then slipt your data in
2 with queries to load them back in Excel after. Hope it will help. -- Yanick "madlin" wrote: I have more than 66,000 lines of data to import into excel (v.2003). Can I do this without loosing data? -- mad ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a import data from a text file to an excel worksheet
Can you split the text file into 2 files, and then import each of those as a
seperate sheet into XL? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "madlin" wrote: I have more than 66,000 lines of data to import into excel (v.2003). Can I do this without loosing data? -- mad ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do a import data from a text file to an excel worksheet
I would first import them to a ACCESS table and then export from ACCESS to
Execel. "madlin" wrote: I have more than 66,000 lines of data to import into excel (v.2003). Can I do this without loosing data? -- mad ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAN I IMPORT DATA FROM A CLOSED FILE TO A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
| Find first blank row in worksheet to import data from txt file | Excel Discussion (Misc queries) | |||
| import multiline data from text file | Excel Discussion (Misc queries) | |||
| how to import more than 1 text file into the same Excel worksheet. | Excel Discussion (Misc queries) | |||
| import data from a text file | Excel Discussion (Misc queries) | |||
Linear Mode
