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

Senin, 14 Desember 2015

Re: [MS_AccessPros] Import data from excel to MSAcceas

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