Morpheus7
asked on
File import with no column names
Hi,
I would like to import a file into a Database table. The file has no column headers and 160 columns. The columns will remain in the same position in the file. Currently, I am doing this by manually mapping the columns using the Import process in SQL. As this is going to be a regular requirement, is there a way to automate this process?
Any guidance would be appreciated.
Thanks
I would like to import a file into a Database table. The file has no column headers and 160 columns. The columns will remain in the same position in the file. Currently, I am doing this by manually mapping the columns using the Import process in SQL. As this is going to be a regular requirement, is there a way to automate this process?
Any guidance would be appreciated.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.