ofafa72
asked on
Import a .txt file into access - With specs
My Text file name is: stjservx_APRIL07.txt
My access tableName is : ServiceAnalysis_TempHolder
My specs table name is: MSysIMEXSpecs
I want a macro that will import the text file into Access. In this process, I do not want to exclude my specs in my process. Please help.
is this the same process if I want to export to .txt file If I have specs too.
My access tableName is : ServiceAnalysis_TempHolder
My specs table name is: MSysIMEXSpecs
I want a macro that will import the text file into Access. In this process, I do not want to exclude my specs in my process. Please help.
is this the same process if I want to export to .txt file If I have specs too.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Never mind. Error on my part. I was using the wrong SpecTableName.
Thanx for you help
Thanx for you help
ASKER
Using the same filename, what would be the reverse (Export to text)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
ASKER
"The text file MSysIMEXSpecs deos not exist you can not import, export or link using the specification"
I have always had trouble with import export, please help