excel max row number

I have a database on Microsoft Access that contains 228825 rows!
I need to export it to excel in one file.When I try to do that I get errors due to NOT ENOUGH ROWS.What can I do ?
How can I export this database in Excel?
Thank you in advance for your help
Regards,
Razvan

Thank you for your prompt answer !
I tried your suggestions but:
-the macro was only for text files
-the software that imports the data from the Excel file to an Access file does not accept Excel 2007 files ( I did try)

I need to import the data from a Access file to RentHIstory.xls without
changing any fields on the Excel file.(see attached)
The problem is that the Excel file has only 65000 rows and the Access file has
over 250000, so I was thinking that having more then one sheet on the Excel file will help but I didn't manage to have a macro that will direct the import from one sheet to the other in the file RentHistory.
Thank you all in advance.

I need to import the data from a Access file to RentHIstory.xls without
changing any fields on the Excel file.(see attached)
The problem is that the Excel file has only 65000 rows and the Access file has
over 250000, so I was thinking that having more then one sheet on the Excel file will help but I didn't manage to have a macro that will direct the import from one sheet to the other in the file RentHistory.

Thank you all in advance.

Hi

The following is pretty clunky but will at least get you the data.

Make sure that your output file has sufficient sheets to house the data (I've used 65000 rows as the cut off point), you are on the first sheet and then run. You will have to adjust the selection criteria and the output criteria to suit.

This will select all the data from a database called c:\temp\test3.mdb, a table called access_table2. This table has 3 columns (expand to suit) that will be output starting in A2.

Please Login or Register  to view this content.

HTH

rylo

Hi

Another version.

Please Login or Register  to view this content.

rylo

Hi

Have you tried the code(s) I put up for you? If so, how did they go?


rylo

Dear rylo,

1.I followed your instructions renaming test3.mdb with the database file where I need to import too and access_table 2 with the file where I need to import from.
I run the macros in test3.mdb and I got the following message

Compile error:
Sub or Function defined

2.I need also to ask you few more questions:
-how can I delete in the big access data base for e.g from row 66000 to row120000
-I need a macros to copy from an Excel2003 file to access2003 some fields.for e.g

excel file

REFERENCE COLOUR
10000 red
10001 bleu
10002 yellow

access file

REFERENCE COLOUR
10000
10000.02
10001
10001.02
10001.03
10002
10002.02
10002.03

As seen above I need the colour name to be pasted to the field COLOUR in the access data base the same for all references that start with the same first number until the point (see below)

REFERENCE COLOUR
10000 red
10000.02 red
10001 blue
10001.02 blue
10001.03 blue
10002 yellow
10002.02 yellow
10002.03 yellow

I want to thank you again for your efforts.If you ever come to Cyprus you have to visit me.
I wish I knew as much as you do!

Thank you