That's the way if you have to do, but may be you can do the same thing
in much more automated way. Here the instructions for do-it that:
1. Import the Excel via the Wizard Get External Data and Create a new
table.
2. Rename this table to TemporalExcel or other name that you please you,
change the length fields or the type if you like it.
3. Create a Form and use this function to import your Excel.
Function ImportXLS(FileToImport as String,DestinationTable as String) As
Boolean
On Error GoTo ImportError
Dim Flag As Boolean
Flag = True
DestinationTable="[" & Trim(DestinationTable) & "]"
DoCmd.SetWarnings False 'This is for avoiding
DoCmd.RunSQL "DELETE * FROM " & DestinationTable
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
DestinationTable, FileToImport, True
DoCmd.SetWarnings True
ExitImport:
ImportXLS = Flag
Exit Function
ImportError:
MsgBox Err.Description
Flag = False
Resume ExitImport
End Function
If you like it contact me for more about, I have other functions for
import Excel file to Access and apply transformations to the data and
then copy to the final table.
--- In [email protected], TJ <[EMAIL PROTECTED]> wrote:
>
> In Access, Click on File/get external data and select your Excel
Worksheet.
> Follow instructions on Screen. This will create a table in Access.
> If it is a regular monthly requirement you may consider VBA code to
do this.
> tj
>
> Toby [EMAIL PROTECTED] wrote:
>
> I have (and will be getting monthly) Excel reports. I need to suck
> that information into my Relational Access Database for running
> queries, and making reports.
>
> The information in the Excel reports includes Personnel Number, Last
> Name, First Name etc., and the hours they worked under specific charge
> codes.
>
> What are some options for bringing this data into Access? Can it be
done?
>
> Thanks,
>
> Toby
>
>
>
>
>
>
>
>
>
>
>
>
> Janardanan Therampath [TJ]
>
> 13171 All American Road
>
> Fishers, IN 46037
>
> 317-773-6216 Home
>
> 317-439-3441 Cell
>
> [EMAIL PROTECTED]
>
> [EMAIL PROTECTED]
>
>
>
>
>
> ---------------------------------
> Shape Yahoo! in your own image. Join our Network Research Panel
today!
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
