Is it possible to change the default delimiter from a comma to a pipe in Access? I want to create tables on the fly based on text files with different numbers and names of fields, but they're delimited by the pipe symbol. I don't want to create these by hand and then create import specifications for each one. Thanks.




Reply With Quote