Export query results by segments (1 Viewer)

linus

New member
Local time
Today, 03:41
Joined
Feb 13, 2020
Messages
7
Hi everyone,
I was wondering if there is any way to export data from a query by segments to prevent exceeding the maximum possible value set by Access

thanks

BTW, excuse me for my nad english
 

namliam

The Mailman - AWF VIP
Local time
Today, 09:41
Joined
Aug 11, 2003
Messages
11,519
How do you mean? Access doesnt have any limits, excel now a days is 1 mio records, doubt you will hit that.

So what is your exact requirement?
 

linus

New member
Local time
Today, 03:41
Joined
Feb 13, 2020
Messages
7
when i try to export a query to an excel file a message tells me that I exceeded the maximum clipboard size
1581608437472.png
 

theDBguy

I’m here to help
Local time
Today, 00:41
Joined
Oct 29, 2018
Messages
8,713
Hi. How exactly were you trying to do the export? Were you using the menus or copying and pasting from the table?
 

linus

New member
Local time
Today, 03:41
Joined
Feb 13, 2020
Messages
7
im right-clicking my query, then -> Export -> Excel. Just like that:

1581609889619.png
 

theDBguy

I’m here to help
Local time
Today, 00:41
Joined
Oct 29, 2018
Messages
8,713
Hi. Thanks for the clarification. And how many records are in the table Consulta2?
 

namliam

The Mailman - AWF VIP
Local time
Today, 09:41
Joined
Aug 11, 2003
Messages
11,519
what version of office are you using?

Docmd.transerspreadsheet
or
Docmd.transfertext (into a .csv file)
will export your table just fine I think
 

theDBguy

I’m here to help
Local time
Today, 00:41
Joined
Oct 29, 2018
Messages
8,713
Hi. Just as a test, could you please try the following steps?

1. Press Ctrl+G
2. Type the following and hit Enter:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12xml, "Consulta2", CurrentProject.Path & "\Consulta2.xlsx", True
3. Close or minimize Access and then look in the same folder for a file called "Consulta2.xlsx" or tell us if you got an error with the above.
 

linus

New member
Local time
Today, 03:41
Joined
Feb 13, 2020
Messages
7
Hi. Just as a test, could you please try the following steps?

1. Press Ctrl+G
2. Type the following and hit Enter:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12xml, "Consulta2", CurrentProject.Path & "\Consulta2.xlsx", True
3. Close or minimize Access and then look in the same folder for a file called "Consulta2.xlsx" or tell us if you got an error with the above.
Thanks, it works perfectly
 

theDBguy

I’m here to help
Local time
Today, 00:41
Joined
Oct 29, 2018
Messages
8,713
Thanks, it works perfectly
Okay, I've never had any problem doing it the way you were doing, but are you okay using code like the one I showed you, at least for this one particular table? If so, do you need any help implementing it?
 

linus

New member
Local time
Today, 03:41
Joined
Feb 13, 2020
Messages
7
Okay, I've never had any problem doing it the way you were doing, but are you okay using code like the one I showed you, at least for this one particular table? If so, do you need any help implementing it?
No, im fine now ;) Thx
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom