Showing posts with label mdb. Show all posts
Showing posts with label mdb. Show all posts

Wednesday, March 28, 2012

How to validate the file in SQL Server 2000

How to Validate the .txt, .xls, .mdb, .doc file in SQL SERVER 2000?

If anybody knows, I would appreciate help?

Thanks

hi,

what do you mean validate. Does it mean that file exist? or file is not damage?

please be more specific

thanks

joey

|||

Hi,

Thanks for reply.

I have file .txt,.xls,.mdb,.doc file. I want to load and validate that file format in SQL 2000. I have to do Data Transformation in SQL 2000.

I have different different file of .txt (meaning data is not consistent) and I want to make one fixed format (for consistency of data) for .txt (same way for .xls,.doc and .mdb).

So, I want to validate that file, how I can validate it?

I really appreciate your help and suggestion.

Thanks

|||

hi,

are you referring to the validity of data ?

or the validity of the file system ?

if you are referring to the validity of data

there is no easy way of doing this but

inspecting the files on your own.

if you want to make your task easier

what you can do is to load the data into a staging table

in Sql server. do the cleansing of the data using tsql update, delete

when your done cleansing the data in the staging table

you can then load it to your production table

regards,

joey

Monday, March 12, 2012

How to use MSDE to link data in Access

I have data in Access mdb file. I wish to link or load data into MSDE 2000.
How to do it ?
I believe there is an "Upgrade Wizard" inside Access that will do that for
you.
Dennis
"hkappleorange" <hkappleorange@.yahoo.com.hk> wrote in message
news:%23CDjN2Z4FHA.252@.TK2MSFTNGP15.phx.gbl...
>I have data in Access mdb file. I wish to link or load data into MSDE 2000.
> How to do it ?
>

Friday, February 24, 2012

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
--
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.
BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>
|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.