473,320 Members | 1,879 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Import Specs

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
3 4531
NeoPa
32,556 Expert Mod 16PB
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
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
14,534 Expert Mod 8TB
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

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

Similar topics

2
by: Alok | last post by:
Hi, I recently upsized my access database to an ADP project with SQL backend. However when I did it the import/export specs were not ported to the new database. Also in the ADP files I am unable...
1
by: Dan | last post by:
Could someone please help me with auto importing a series of data files into an Access table. I tried to follow code given below in a previous messagebut i'm getting error messages. Here's my...
1
by: Methven | last post by:
File - Get External Data - Import - Text Type - Advanced - Specs PROBLEM Can anyone assist me with a problem ? When attempting to specify an import specification using ; File - Get External...
3
by: Trev | last post by:
Is there a way to create/manipulate import specs in VBA?
1
by: PeteCresswell | last post by:
I'm just starting in 2003, hoping to find a more direct route to editing/listing Import Specifications than in 2000 - where you have to initiatate an import, choose "Advanced", and then load a...
3
by: deko | last post by:
I've been trying to use the Access Import Wizard to expedite importing data into my mdb. The nice thing about the wizard is that I can import from different file formats - txt, xls, even Outlook -...
1
by: praz | last post by:
Hi, I am trying to import a delimited text file using a macro. The problem is i am not able to generate a Primary key (Let access add primary key). I have tried saving the import specs using the...
4
by: Regnab | last post by:
I'm automating the import of all text files into Access from a source folder. I was getting the "Field 'F1' doesn't exist in destination table" error, so I checked it out on the net and it said to...
0
by: Zeeshan7 | last post by:
We can use import Specs in ms access to import text files etc. Can we create import specs in sql server 2000 (home edition)? Please help. Thanks
2
by: pendell | last post by:
I am working with a client running 2003 Access. Some time ago I built them an import spec for use with the Import Wizard. Several months later, I have been called back and asked to solve a...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.