Excel to an Access DB

[chuckomalley]

I have an office that would like to have an Excel Spreadsheet with a training
roster put onto our website with the ability to Insert/Update/Delete. I can
handle the latter part of the request, but does anyone out there have a
tutorial, etc. for converting the spreadsheet to an Access table quickly and/or
easily?

Is it also possible to insert updated data from their spreadsheet later, or
once we make it dynamic, should they discontinue using Excel and stick with the
dynamic forms I will create for it? In other words, can I use both to make
updates?

Cheers

Chuck

[Julian Roberts]

In Access, go File > Get External Data > Import and navigate to your Excel
file. Then follow the import wizard. You'd be better off keeping your data
in Access, much easier to manage than in Excel.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Joe Makowiec]

On 20 May 2005 in macromedia.dreamweaver.appdev, chuckomalley wrote:

> I have an office that would like to have an Excel Spreadsheet with a
> training roster put onto our website with the ability to
> Insert/Update/Delete. I can handle the latter part of the request,
> but does anyone out there have a tutorial, etc. for converting the
> spreadsheet to an Access table quickly and/or easily?
>
> Is it also possible to insert updated data from their spreadsheet
> later, or
> once we make it dynamic, should they discontinue using Excel and
> stick with the dynamic forms I will create for it? In other words,
> can I use both to make updates?

As I Understand It, you can do a database connection directly to an Excel
spreadsheet. (I've never tried it.) Apparently, you have to use named
ranges in order for it to work. I'm guessing that using Excel directly,
or trying to do Access imports from Excel, would be painful.

As Julian suggests, have the client go straight Access, or get the
dynamic stuff implemented and have them use the web interface.

--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]

[chuckomalley]

Thanks a lot. That's exactly what I'll do.

Cheers

Chuck