Receive an error in importing excel file into access (1 Viewer)

E

elly.khanlar

Registered User.

Local time

Today, 12:41

Joined

Oct 3, 2019

Messages

23

• Jan 7, 2020

• #1

Hi All,

I get below message when import an excel file into the database:

an error occurred trying to save import/export specification


Your help is greatly appreciated!

 

theDBguy

I’m here to help

Staff member

Local time

Today, 09:41

Joined

Oct 29, 2018

Messages

21,467

• Jan 7, 2020

• #2

Hi. Unfortunately, the error message is a little vague. Can you tell us a little bit more about what you were doing and how exactly you were doing it? Thanks!

 

E

elly.khanlar

Registered User.

Local time

Today, 12:41

Joined

Oct 3, 2019

Messages

23

• Jan 7, 2020

• #3

theDBguy said:

Hi. Unfortunately, the error message is a little vague. Can you tell us a little bit more about what you were doing and how exactly you were doing it? Thanks!

Click to expand...

I tried to import an excel file from external data option in access, after following importing steps, in final steps I received this error message

 

isladogs

MVP / VIP

Local time

Today, 17:41

Joined

Jan 14, 2017

Messages

18,213

• Jan 7, 2020

• #4

So you couldn't save the import specification?
Did the import work successfully?