"The changes you requested to this table were not successful because they would create duplicate values in the index, the primary key, or relationship. With Windows 7, it seems that this practice leads to the following error when the file is imported to Access: txt extension (in the file name itself without opening) and was able to import the file into Access without issue. I have a file exported from an accounting system that has no extension. How do I assign a variable to original code page and not have it reset to the default Windows (ANSI)? However, the macro recorder assigns a code page number to the TextFilePlatform property. ![]() QueryTable.TextFilePlatform has a number that refers to one of these constants. XlPlatform can be one of these XlPlatform constants.Īnd. ![]() This works fine for all parameters except TextFilePlatform. I want to set the connection parameters to variables and reapply them with a different filepath.ĭim TabDelimiter as Boolean, CommaDelimiter as Boolean ![]() I am writing a macro that changes the filepath for an existing text file import as a QueryTable.
0 Comments
Leave a Reply. |