Prev: IIf
Next: Query Results Where Qty Shipped is not Divisable by 4
From: Rajeev Rawat on 19 Feb 2010 08:44
Can Excel data be imported into Access easily!? I know from Word table
I can simply copy and paste but it is not that easy when doing from
Excel to Access!

I downloaded this manual from http://www.mousetraining.co.uk/training-manuals/Access2003Intro.pdf
but couldn't find this topic

If anyone knows please let me know!

Cheers

Raj
From: Stefan_889_12 on 19 Feb 2010 09:33
Hello,

there are plenty of sources.
e.g.:
http://office.microsoft.com/training/training.aspx?AssetID=RC102722321033

Stefan.

"Rajeev Rawat" wrote:

> Can Excel data be imported into Access easily!? I know from Word table
> I can simply copy and paste but it is not that easy when doing from
> Excel to Access!
>
> I downloaded this manual from http://www.mousetraining.co.uk/training-manuals/Access2003Intro.pdf
> but couldn't find this topic
>
> If anyone knows please let me know!
>
> Cheers
>
> Raj
> .
>
From: Ken Snell on 19 Feb 2010 11:29
Some code examples as well:

http://www.accessmvp.com/KDSnell/EXCEL_Import.htm


--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Rajeev Rawat" <rajeev.rawat1(a)googlemail.com> wrote in message
news:53c5fbf7-6e3d-4b2c-b9d9-54d39e4de48b(a)z11g2000yqz.googlegroups.com...
> Can Excel data be imported into Access easily!? I know from Word table
> I can simply copy and paste but it is not that easy when doing from
> Excel to Access!
>
> I downloaded this manual from
> http://www.mousetraining.co.uk/training-manuals/Access2003Intro.pdf
> but couldn't find this topic
>
> If anyone knows please let me know!
>
> Cheers
>
> Raj


From: John Caulfield on 19 Feb 2010 14:28
No need for code. Create an Eccel File and range name the headings and data and Save the File.

Then Use File Import and work your way through the steps of the Wizard.

Alternatively, Access has a Macro action Transfer Spreadsheet which has all the settings needed to import without Code.

Even if you did want code the Tools MAcro Menu has an option to Convert a Macro to VBA code.

Steps for range naming in Excel are conatined in the advanced manual 2003 or 2007 at the same site http://www.mousetraining.co.uk/ms-training/microsoft-excel-training-courses.html

---
frmsrcurl: http://msgroups.net/microsoft.public.access.queries/Importing-Excel-data-into-Access
 | 
Pages: 1
Prev: IIf
Next: Query Results Where Qty Shipped is not Divisable by 4