How do I import an excel file to a table with out it being Linked?

[smc678]

How do I import an excel file to a table with out it being Linked? I have a data base that works off of a table that is currently linked to a excel file. This file needs to be updated through out the day with all new data each time. But if i have the database open I cannot update the excel file. Is there a way I can just pull the data from the excel file?

[June7]

You can import data with Import wizard or use VBA code to open an Excel object and read in the data to table one cell at a time or use VBA to establish the link when needed. http://social.msdn.microsoft.com/For...-a6489161091b/

[smc678]

Im receiving a run-time error 3918 ? this is the code i used.

Private Sub Command22_Click()
DoCmd.TransferSpreadsheet acImport, 3, _
"TBLAgedCartons", "P:\Shared\AGED\crViewer.xls", True, "A:O"

[June7]

Not familiar with that error.

Referencing cell range is tricky. Need the sheet name prefix. First try the import without the range reference. It is an optional argument

[smc678]

I dont get it. I used the other example and this is what is stoping the code. Any ideas?
Private Sub Command22_Click()
Dim strPathFile As String, strFile As String, strPath As String
Dim strTable As String
Dim blnHasFieldNames As Boolean
' Change this next line to True if the first row in EXCEL worksheet
' has field names
blnHasFieldNames = True
' Replace C:\Documents\ with the real path to the folder that
' contains the EXCEL files
strPath = "C:\Users\smc678\Documents\AGED"
' Replace tablename with the real name of the table into which
' the data are to be imported
strTable = "TBLAgedCartons"
strFile = Dir(strPath & "*.xls")
Do While Len(strFile) > 0
strPathFile = strPath & strFile
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
strTable, strPathFile, blnHasFieldNames
' Uncomment out the next code step if you want to delete the
' EXCEL file after it's been imported
' Kill strPathFile
strFile = Dir()
Loop
End Sub

[June7]

Step debug. Check the values of variables as the code runs. Review link at bottom of my post for guidance on debugging techniques.

I think you will find that the concatenation of path and file strings are missing '\' character.

BTW, yellow highlight is hard to read, use red.