#Microsoft activex data objects ado download for mac how to#What we couldn’t figure out was how to work around that problem. Obviously the space in the file name Fabrikam Employees.txt is causing problems that we could figure out. But here’s what we got when we ran the script: Microsoft JET Database Engine: Syntax error in FROM clause. No big deal, right? After all, you just change the value of the variable strFile to this: strFile = “Fabrikam Employees.txt” So what’s the problem? Well, suppose our text file is named Fabrikam Employees.txt. This works great: the script will run, and it will report back the name, department, and title of all the Fiscal Specialists. #Microsoft activex data objects ado download for mac code#Here’s the line of code that specifies the name of the file we want to work with: strFile = “Employees.txt” What we’re doing here is connecting to the folder C:\Scripts\Text files and then querying the file Employees.txt. ObjConnection, adOpenStatic, adLockOptimistic, adCmdText ObjRecordset.Open “SELECT * FROM ”
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |