IMPORTING EXCEL INTO ACCESS

  • Thread starter Thread starter Theo
  • Start date Start date
T

Theo

(Please send more information)
I am assuming that you are selecting File | Get External
Data | Import ...

Try this:

View all file types and file name extensions
In My Computer or Windows Explorer, open the folder you
want to view files in.


On the View menu, click Options.


To see all file types, click Show All Files on the View
tab.
To see all file name extensions in Windows 95, clear the
Hide MS-DOS File Extensions For File Types That Are
Registered check box on the View tab.

To see all file name extensions in Windows 98, clear the
Hide File Extensions For Known File Types check box on the
View tab.

Note The last two settings control whether or not the
file extensions are displayed in the Files of Type list of
the Open, Export, Import, and Link dialog boxes.


Theo := MS Access Help
 
-----Original Message-----

(Please send more information)
I am assuming that you are selecting File | Get External
Data | Import ...

Try this:

View all file types and file name extensions
In My Computer or Windows Explorer, open the folder you
want to view files in.


On the View menu, click Options.


To see all file types, click Show All Files on the View
tab.
To see all file name extensions in Windows 95, clear the
Hide MS-DOS File Extensions For File Types That Are
Registered check box on the View tab.

To see all file name extensions in Windows 98, clear the
Hide File Extensions For Known File Types check box on the
View tab.

Note The last two settings control whether or not the
file extensions are displayed in the Files of Type list of
the Open, Export, Import, and Link dialog boxes.


Theo := MS Access Help


.
I am using Windows XP and Access 97 from Office 97. I
Click to expand...
did what you suggested but in the view button there is no
option. Under tools there is options and a view tab but
nothing about file ext. As I stated earlier Access
states to reconfigure using the value pack which I did
but when I do the drop down from the import screen for
file type Excel is still not listed.
 
Back
Top