I found this subject throughout the forums regarding the migration from older versions of ADB to new. Most suggest getting almost every iteration of access from the start to now but I only have 97 that someone at work just handed me and 365 (2016)... With being limited as such, I started trying to think of a way to do this systematically. I think I read somewhere in the forums that a user was trying to do the same thing and that "My task does not involve streamlining/optimizing." I am in the same dilemma and every time I glance at this program, it breaks my heart that someone abused access like this.
Just to accomplish the task at hand, I wrote a script in 97 that exported every table to excel. From there in 2016, I wrote a similar script to import them which seemed to work. I have yet to compare formatting and I'm sure with the 239 tables, there's an issue as such.
Please feel free to annihilate this...
Code:
Public Sub ImportXLFiles()
Dim myfile As String
Dim theName As String
Dim mypath As String
mypath = "G:\ExpTbls\SaveExp\"
ChDir (mypath)
myfile = Dir(mypath)
Do While myfile <> ""
If myfile Like "*.xls" Then
theName = Left(myfile, Len(myfile) - 4)
DoCmd.TransferSpreadsheet acImport, 8, theName, (mypath & myfile), True
End If
myfile = Dir()
Loop
End Sub
Can I do something similar for queries (too many to count) and macros (23)?
What would be an easy way to tackle the formatting?
There's only 5 Forms so recreating those ones once the data is moved will be cake but there's more reports than I can count.
Also, the switchboard manager is used and it's been so long since I looked at that. Does 2016 even have that anymore?
Any help would be appreciated.