Re: How can I transfer an Excel worksheet onto an Access database?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Actually, it is probably safer to assume that I know absolutely nothing about
Access. The worksheet is already set up, but I guess what I need to know is
"okay, now what?" Thanks for your help.

"Kevin3NF" wrote:

> File>>Get External Data>>Import
>
> Follow the wizard form there.
>
> This assumes you meant "transfer Excel into my Access table that already
> exists"
>
> --
> Kevin Hill
> President
> 3NF Consulting
>
> www.3nf-inc.com/NewsGroups.htm
>
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
>
> "jess" <jess@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:0D8EDF7D-C1E1-42E0-BED3-E0B9BBFBE5C8@xxxxxxxxxxxxxxxx
> >
>
>
>
.



Relevant Pages

  • Programing Help Needed
    ... to save worksheet as. ... Is there any way to change the home directory for document once it has ... Steve ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Hidden Column
    ... In a worksheet I have a column which sometimes is ... >> How do I use a macro to detect if the column is hidden or not? ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Using buttons to change a columns data
    ... > Id it possible to create a worksheet that has buttons on it, ... > everytime I select a certain button the data in say column c changes, ... > REgards o you all ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Help
    ... larg:confused: e worksheet with many rows, ... only1joal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24589 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Macro to insert formula result into range with zero values in cell
    ... equal to zero in that range. ... If this is more appropriate in worksheet ... Posted only in programming. ... Prev by Date: ...
    (microsoft.public.excel.programming)