How to split worksheet to make smaller

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to split an Excel worksheet into smaller files for importing into a
database. Does anyone know if there is a function or a macro that will do
this for me?
 
try to save as CSV and then import to db

but i never ever have any trouble inserting data from excel to db i mean Accees and Oracle 9.

maybe your`s data is wrong format or smt else.

--
M.A.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting a file with lookup functions into smaller parts 3
Split one worksheet to multiple 1
How to split large audio files on Linux 3
Splitting Worksheet 2
Access Splitting Access Table 0
How to separate Excel Workbooks into new files 0
how to split date and time in one cell into multiple cells 6
VBA Multiple Line handling with Split() 1

Back
Top