By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Import Specs

P: 44
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.
Oct 29 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,347
You can get data from SQL Server in two straightforward ways :-
1. Export your data into an intermidiary format (Text; CSV; etc), then import the resultant file into Access.
2. Create a SQL Server ODBC link to the SQL Server and link normally to the table(s) you want.
Oct 29 '06 #2

P: 44
Hi, I am talking about import/export specifications where we can set field name, data type and width etc.

Is this option available in sql server/ enterprise manager where we can create import/export specifications? Thanks
Oct 29 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Oct 29 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.