Click on File within Access
Click on get external data and within that click in Import.
Find the appropriate file (make sure you select the correct file type)
walk through the spreadsheet wizard.
very easy.
Let me know if you have any other questions regarding this.
kaigler
At 09:11 PM 12/14/00 -0500, you wrote:
>Hi,
>
>Can someone please assist me on how to read an Excel file and take the
>contents to a Access database.
>I have created an Access DB with the same field names and have a DSN set up
>for the Access database.
>
>How do I read the Excel file and insert row by row to the Access DB? Thanks
>in advance.
>
>Pallav
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
