| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing more than 65536 rows from .csv file
On 23 Jan, 00:15, Vamsi Challa <Vamsi
wrote: Hi I am trying import a .csvfilewhich contains more than 65536 rows. I created a macro to import and it is successfully importing with out a text qualitfier. can any one help me how to import huge .CSVfiles to one excel sheet? If you are importing many records, using ADO and CopyFromRecordset will be far quicker than using Line Input# and Split. Could you give a sample of the first few lines of the csv file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing File greater than 65536 | Excel Programming | |||
| Importing File greater than 65536 | Excel Worksheet Functions | |||
| how do I import a CSV file with more than 65536 rows | Excel Programming | |||
| Importing Text File with more than 65536 rows | Excel Programming | |||
| Importing a large text file (65536) | Excel Programming | |||
![Tony James[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
