Smack my hand to my forehead! I never noticed the Advanced button before. What a terrific solution. I have set up the import specification to mirror the table design, complete with indexes. Now my only problem is that my delimited file ends with ".dat" and not one of the acceptable...
I have been using Excel to open up my semi-colon demlimited data file, adding headers, and saving in Excel format to prepare a file to import into Access. Is there an easier way? I have 3 data files to import each week.
I figured out the solution! I'm putting it here in case others have the same puzzling situation:
Dim SendPath, NameFile, SaveAsFile
'
Application.DisplayAlerts = False
'
SendPath = "\\ServerName\DirectoryName\Store01\"
NameFile = "RegularStore01_"
'
SaveAsFile =...
Hi,
I'm running Windows ME. I installed Informix -CLI 2.5. My goal is to export data to Excel using ODBC.
When I try to connect to a data source I receive an error: Specified driver could not be loaded due
to system error 1157 (INFORMIX-CLI 2.5 (32 bit)).
I checked my autoexec bat. It...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.