PC Review


Reply
Thread Tools Rate Thread

How to convert existing Excel List into a table in Access?

 
 
=?Utf-8?B?YW5uYQ==?=
Guest
Posts: n/a
 
      18th Jun 2006
Is it possible to convert existing Excel List into a table in Access database
in 2003 Excel I know it was possible in 2002 version through AccessLinks ?
 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      18th Jun 2006
You can import the Excel list into Access, and use it there as a table.

In Access, choose File>Get External Data>Import
In the Files of Type dropdown, at the bottom of the dialog box, choose
Microsoft Excel
Locate and select your Excel file, and click Import
Step through the Import Wizard, to complete the import.

anna wrote:
> Is it possible to convert existing Excel List into a table in Access database
> in 2003 Excel I know it was possible in 2002 version through AccessLinks ?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

 
Reply With Quote
 
=?Utf-8?B?YW5uYQ==?=
Guest
Posts: n/a
 
      18th Jun 2006
Thanks Debra it is exacly what I m doing I just wondered about that
AccessLinks which were availible through add-in program in 2002 version

"Debra Dalgleish" wrote:

> You can import the Excel list into Access, and use it there as a table.
>
> In Access, choose File>Get External Data>Import
> In the Files of Type dropdown, at the bottom of the dialog box, choose
> Microsoft Excel
> Locate and select your Excel file, and click Import
> Step through the Import Wizard, to complete the import.
>
> anna wrote:
> > Is it possible to convert existing Excel List into a table in Access database
> > in 2003 Excel I know it was possible in 2002 version through AccessLinks ?

>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert a table into a list in excel? scott Microsoft Excel Worksheet Functions 7 30th Jun 2008 03:05 AM
??? how to import excel table to existing access table =?Utf-8?B?SmF5bGlu?= Microsoft Access External Data 5 1st Mar 2007 02:27 PM
Convert an Excel table to a list with VBA u473@aol.com Microsoft Excel Programming 7 1st Jul 2006 11:42 PM
Copying an Excel table into an existing Access table? =?Utf-8?B?QmV0aA==?= Microsoft Access External Data 1 23rd Dec 2005 03:32 AM
Access 2000 - Importing supplier price list into a already existing table ? Johnny Dee Microsoft Access Getting Started 3 6th Mar 2004 06:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:39 PM.