Home |
Search |
Today's Posts |
#1
|
|||
|
|||
import external data too many rows for one worksheet
I have tried to import the file into excel but the file is too big for one
shet. My problem is not that i have too many columns but there is thousands of rows of data Help! |
#2
|
|||
|
|||
import external data too many rows for one worksheet
"Margaret O'Connor" <Margaret wrote in
message ... I have tried to import the file into excel but the file is too big for one shet. My problem is not that i have too many columns but there is thousands of rows of data Help! You want to import data, where from? Which way? Bruno |
#3
|
|||
|
|||
import external data too many rows for one worksheet
Suggestion #1 -
If you have Microsoft Access, import the data into that program instead. You can run simple queries from Access to extract subsets of data that WILL fit on a single worksheet tab Suggestion #2 - Open the file in Notepad. Copy half the data (or one-third of the data) and paste it into a new Notepad window and save that as a new file. Repeat the process until you've created new, smaller files, each of which will fit on a single wrksheet tab Suggestion #3 - Do a Google search for VBA solutions that handle importing large text files into multiple worksheet tabs "Margaret O'Connor" wrote: I have tried to import the file into excel but the file is too big for one shet. My problem is not that i have too many columns but there is thousands of rows of data Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import external data "PROBLEM" | New Users to Excel | |||
How do I import external data populate rows instead of columns. | Excel Discussion (Misc queries) | |||
import external data | Excel Discussion (Misc queries) | |||
Get External Data Web Query new worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |