Ok, I had this working, now it gives me error whenever i try to copy the table.
this is the code that gives me troubles.
strFolder = InputBox("What name of directory?" & vbCrLf & "NO SPACES!!", "CD Folder Name", strPath)
strcommand = "SELECT * INTO " & strFolder & " FROM default"
On Error GoTo Error
it hits the dbsFiles.execute strcommand and tells me the variable not defined error.
I have no idea why.. It was working, would grab whatever you typed into the message box for the table name, then drop the files into that table.
I need it to grab each file and drop it into a new table. I'd use 1 table, but there are going to be hundreds if not over a thousand files listed.... I need the option to change the filename as well...