Importing Data from ACCESS into SQL Server 2005

  • Thread starter Thread starter Shane Jones
  • Start date Start date
S

Shane Jones

I've inherited a project which has numerous fields that have extra spaces in
them -- this is causing a problem with data Inserts, Edits, and Deletions in
my .ASP Website.

I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need
to know if there's a way that I can Right Trim all fields on the imported
tables during the Import Process.

Will I have to scrub all these tables in ACCESS before hand, or is there a
much simplier method to trim the spaces during import.

Thanks in advance for any ideas offered.

Shane
 
Why posting to so many newsgroups? Second, m.p.a.adp.sqlserver is about ADP
and SQL-Server and not about upzising problems or problems with only
SQL-Server.

Finally, are your extra spaces in the Access tables before their importation
to SQL-Server or after? Is it's after, then I suspect that you have used
fields of type char and nchar instead of varchar and nvarchar.
 
Sylvain,

Sorry for the Cross-Posting -- I'v been told (by another MVP) that
Cross-Posting is preferred to posting duplicates in several different
groups -- I wasn't sure which group this applied to best (nor which groups
got the most traffic -- as some have only sparse posts).

The extra spaces are in the ACCESS db before importing them to SQL Server --
needless-to-say -- I inherited a mess of data. I'm looking for a way to
RTRIM all fields in all tables (without having to write seperate query
statements for each) -- can this be done?

Thanks in advance for any pointers.

Shane
========================
 
I've inherited a project which has numerous fields that have extra spaces
in
them -- this is causing a problem with data Inserts, Edits, and Deletions
in
my .ASP Website.

I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I
need
to know if there's a way that I can Right Trim all fields on the imported
tables during the Import Process.

Will I have to scrub all these tables in ACCESS before hand, or is there a
much simplier method to trim the spaces during import.

Thanks in advance for any ideas offered.

Shane
 
Shane Jones said:
I've inherited a project which has numerous fields that have extra spaces
in
them -- this is causing a problem with data Inserts, Edits, and Deletions
in
my .ASP Website.

I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I
need
to know if there's a way that I can Right Trim all fields on the imported
tables during the Import Process.

Will I have to scrub all these tables in ACCESS before hand, or is there a
much simplier method to trim the spaces during import.

Thanks in advance for any ideas offered.

Shane
 
Back
Top