ACCESS FEED: Re: Re: [MS_AccessPros] Import data from excel to MSAcceas

Senin, 14 Desember 2015

Re: Re: [MS_AccessPros] Import data from excel to MSAcceas

Siguard,

Actually, I want to achieve this: when clicking on a button, a pop up window will show from where I want to import, then follow the steps to complete the importing procedure. What you suggest is that , I have to import something previously and save the name. Which is not quite applicable in this situation. Is it possible to achieve what I expected? Thanks in advance.

Best Regards,

Kevin

From: Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals]
Date: 2015-12-15 09:48
To: MS_Access_Professionals
Subject: Re: [MS_AccessPros] Import data from excel to MSAcceas

After you manually go through the import and give it a name, yes - this worked for me.
I was importing from a text file but I would expect this process to work to import from Excel as well.
Sigurd

On 12/14/2015 8:33 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] wrote:

Sigurd-

Thanks a lot. So the last code line can be used in VBA to import excel, right? I am going to try at office today. Thanks again.

Best Regards,

Kevin

发自我的小米手机

在 "Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年12月15日上午9:21写道：

I have just dealt with this today.
Both the method I was using and the one that worked are based on using an import specification.
(by "import specification" I mean going to External Data, Import (various types of files possible).
After going through various steps, you're given the chance to save the specification (based on the
steps just taken) with a name. Remember this name.

In an application developed with an earlier version of Access, I was using
CurrentProject.ImportExportSpecifications("import-spec-name").Execute (False)

Wouldn't work with a newly defined import. With a little research I found
DoCmd.RunSavedImportExport ("import-spec-name")
which worked just fine for me.

Sigurd Andersen

On 12/14/2015 7:04 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] wrote:

Dear All,

What is the code for importing data from excel to MS Access? Thanks.

Best Regards,

Kevin