cancel
Showing results for 
Search instead for 
Did you mean: 

error while copying data from .mdb file

0 Kudos

Hi,

I am using .MDB file to run queries on different tables.

When i executed a query , i got more than 78000 records. when i tried to copy this output , i am getting error as there are many records.

can anyone suggest a solution rather than copying manually.

Accepted Solutions (0)

Answers (2)

Answers (2)

karthick_ravichandran
Participant
0 Kudos

Hi nithya,

Try to copy that file in to .xlsx or csv format.

BR,

karthick

0 Kudos

but my template is .xls format... it can accommodate oly 65536 rows only 😛

Former Member
0 Kudos

Apply some filter to reduce the no of records in one tab. create one more tab and keep the remaining records

Former Member
0 Kudos

It depends on what you would like the output data to be made available. Please specify

0 Kudos

i want it to copy that output into Excel

Former Member
0 Kudos

older version of excel will accomidate only 65341 ROWS, hence i would request you to copy as XLSX or CSV Formate.

or

Apply some filter to reduce the no of records in one tab. create one more tab and keep the remaining records.