Forum Home
Press F1
 
Thread ID: 99495 2009-05-04 07:08:00 Split Excel file into smaller files Miami Steve (2128) Press F1
Post ID Timestamp Content User
770859 2009-05-04 07:08:00 I have an application that can accept input from an Excel file. However, it has a limit on the number of rows it can process. The Excel file I start with has 2 to 3 times the number of rows the application can handle, so I need to split the original file into smaller files, preferably without manual intervention. Can I do this?

I currently have an Access DB that imports the file, deletes duplicates and then exports a new file, so if I can do something with Access to split it that would be ideal.
Miami Steve (2128)
770860 2009-05-04 09:10:00 This help?:
en.allexperts.com

Blam
Blam (54)
770861 2009-05-04 23:19:00 Sorry for the late reply blam.... will give that a go today

Thanks
Miami Steve (2128)
1