![]() I tried changing the previous macro to sub in the new information, but when I run it nothing seems to happen. Provider=SQLOLEDB.1 Persist Security Info=True User ID=sa Initial Catalog=CATALOGNAME Data Source=COMPUTERNAME\PROGRAMNAME Use Procedure for Prepare=1 Auto Translate=True Packet Size=4096 Workstation ID=COMPUTERNAME Use Encryption for Data=False Tag with column collation when possible=False The new connection string looks like this: If I copy and paste the connection string from within Excel, the one that worked with the above, it looks like this:ĭSN=Visual FoxPro Tables UID= SourceDB=c:\FOLDERNAME\SUBFOLDERNAME SourceType=DBF Exclusive=No BackgroundFetch=Yes Collate=Machine Null=Yes Deleted=Yes ![]() " SourceType=DBF Exclusive=No BackgroundFetch=Yes Collate=Machine Null=Yes Deleted=Yes " _ "ODBC DSN=Visual FoxPro Tables UID= SourceDB=", _ ![]() Const strPath As String = "c:\FOLDERNAME\SUBFOLDERNAME"įor Each wks In ActiveWorkbook.Worksheets
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |