Size of the Access Database imported from Excel Sheet in 2007

S

sanits591

Active Member
Joined
May 30, 2010
Messages
253
Hi,

The size of the excel file (.xlsx, 837kb, with 64k cells filled up with text note more than 25 in any cell) imported in MS access is having a size of database (2856kb),more than expected.

Please help me out in this, as i need to import 2.8Mn cells of this type in MS access database, which shall make it inconvenient to handle in this.

Thanks!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
sanits591 said:
Hi,

The size of the excel file (.xlsx, 837kb, with 64k cells filled up with text note more than 25 in any cell) imported in MS access is having a size of database (2856kb),more than expected.

Please help me out in this, as i need to import 2.8Mn cells of this type in MS access database, which shall make it inconvenient to handle in this.

Thanks!
Click to expand...

Did you set the fields in Access to 25 characters? or are they still at 255? Also, in the settings, you can "Compact on Close", too. ;)
 
Upvote 0
What method are you using for the import into the database? As if like copy and paste the Table that is created automatically sets the Field Size for Text to 255 characters.

Have you looked at compacting the database once the data has been transfered!

Select the Office Button in the database and then Manage then Compact
 
Upvote 0
Before posting, i tried for compacting the database also, but no results, the database remained of the same size.

I did not set any field to any limitation of characters, i just gave an example to have a view of the type of database.

Thanks!
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
How Do I? ... Import New Data from Excel into Access, keeping the queries ?
Replies
6
Views
288
PurrSent
P
A
  • Question Question
Efficiently Importing Large Records to MS - Access
Replies
8
Views
1K
jackd
J
C
  • Question Question
Error Importing Excel data into Access
Replies
9
Views
9K
Micron
M
T
  • Solved
Problem suppressing the printing of Access report (from Excel)
Replies
7
Views
3K
Micron
M
D
  • Question Question
Export from Access to Excel into single file but multiple sheets when table exceeds 1.04M rows
Replies
3
Views
1K
DanLMiddlingExcelUser
D

Forum statistics

Threads
1,224,600
Messages
6,179,834
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top