unable to create relationship, not an unique id..
database included
why this create relationship module, i import multiple excel files in to mutiple tables
and each table need to be linked to the main table _match _skill _ player
Hello,
i have the following module created to create a relation between
table '_match' with column 'match' and table '05-as2910 = WrksheetName' , column 'as2910 - teamdat'
when running i receive this error :
Creating Relations...
The database engine could not lock table '_match' because...
hello,
my customerfile is C:\david\axor\01-mavo2409.xlsx
with this code "file = Mid(CustomerFile, InStrRev(CustomerFile, "\") + 1)"
i receive this 01-mavo2409.xlsx
i want to remove the .xlsx extention
how can i do it
Hello,
i use this code to import xls file in access
Sub ImportXLS()
' importeer xls bestand
Dim WrksheetName As String
Dim i As Integer
Dim xl As Object
Set xl = CreateObject("Excel.Application")
xl.Visible = True
xl.Workbooks.Open "C:\david\axor\01-mavo2409.xlsx"
With xl
.Visible = True...