Hi,
I have posted a question in sql server forum but have not received any response as yet. Please help to create import specs for sql server. This feature is available in ms access where we can set column width etc. I do not know how and where to create import specs for sql server 2000 (home edition) / enterprise manager to import text files etc.
Thanks.
You can do an export from Access instead using VBA code
Create an ODBC connection to the sql server database
You can then run a pass thru sql query to the sql server database
The first to create a table based on field names and widths in access using vba code to build the sql statement and then doing an insert statement to populate the new table.
I'm afraid I don't know what import facilities are available in sql server 2000 but I would guess that they don't have the same type of wizards available as the access import specification wizard.