ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   have to open csv files with possibly more than 65000 rows of data in them, (https://www.excelbanter.com/excel-programming/387763-have-open-csv-files-possibly-more-than-65000-rows-data-them.html)

[email protected]

have to open csv files with possibly more than 65000 rows of data in them,
 
Hello,

I hope someone can help me with this one. I am fairly new to working
with Access DB. I need help with creating a query which can import
CSV. files which are larger then 65,000 rows and then splitting it
into 2 files by projects, which then can be transported back to CSV
files.

Thanks


Himani[_2_]

have to open csv files with possibly more than 65000 rows of data
 
Yes, this can be possible but you have to write a macro for that.

" wrote:

Hello,

I hope someone can help me with this one. I am fairly new to working
with Access DB. I need help with creating a query which can import
CSV. files which are larger then 65,000 rows and then splitting it
into 2 files by projects, which then can be transported back to CSV
files.

Thanks




All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com