undgå export begrænsning

Vil det være en mulighed at dele data op i en række bidder via forespørgsler og eksportere dem enkeltvis?

tja det ville det nok...

hvordan deler jeg så op vha. forespøgrsler??

/smackers

If I am not mistaken Excel only has 65000 rows so why try and export 93000? Make a query which only selects the TOP 65000 and see if it works.

To limit a query to th efrist 65000 right click on th equery when in design view and then select properties and then Top Values. Change this to 650000 or how many you want. You could then export these to one sheet and the rest to another.

You can also place TOP 65000 after the SELECT in SQL VIEW

SELECT TOP 65000 .....

Hi terry,

I\'m not sure (at all) where to put the SELECT command??
can you describe how to in more details <:)

/smackers

Press the NEW QUERY BUTTON and then select simple query wizard. Press OK an dthen choose the fields you want in the result. Press Next. Next, and then select the Modify design radio button. Then Finish. You should now be in design view for your query. Right click on the main window and choose properties from the menu. You should see a field saying TOP VALUES and the value will be set to All.
Change All to 65000. Then save the query. You can now run the query to see the result.
When you export select the query instead of the table