How to make file from Access available in Excel

eliW

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,940
Hi,

I am using a program which produces a file called info1 (no extention).

I know that it can be seen via Accsess, but I do not have Access.

When trying to import this file to Excel - I get gibberish

How can I proccess this data file in Excel vithout having or converting it first in Access?

Is there any freeware utility to make Access files compatible with Excel?

Thank you in advance,

Eli
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Hi,

You can query Access files by using Excel's query functionality:

Click, Data, Get External Data/Import External Data (depends on your version of Excel), New Database Query. This should display a dialog box called 'Choose Data Source'. Choose MS Access Database and then browse to your file. You can then query the file's tables/fields.

Let me know how you get on,

Dan
 
Upvote 0
Dan,

I never even dreamed that this is possible

Thank you so much!

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

Similar threads

E
  • Question
Developing a Lot Tracking Inventory system with QR Codes/Barcodes and Updating Ability
Replies
0
Views
289
Easilyy
E
P
  • Locked
  • Question
Mail Merge - Using Excel & Word, how to select specific criteria ?
Replies
1
Views
149
Fluff
Fluff
P
  • Question
Mail Merge - Address Labels, from Excel, selecting specific criteria, please?
Replies
1
Views
193
FormR
FormR
S
  • Solved
Can't open Excel XLSM file due to recent VBA Reference failing
2
Replies
16
Views
1K
SixSigmaGuy
S
N
  • Question
Excel Crashes when I Save Any File
Replies
4
Views
641
nolass
N

Forum statistics

Threads
1,221,826
Messages
6,162,192
Members
451,752
Latest member
majbizzaki

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