from access to sql

hope you can help.

I need to get my access db backend to sql. I have tried the upsizing
wizard but the get message "overflow" and cannot get any further.

I also use queries that reference two date ranges from forms such as
BETWEEN forms!form1!text1 AND forms!form1!text2. How can i achieve
this in an sql view?You will need lots of advice. I suggest that you buy "Microsoft Access
Developer's Guide to SQL Server". It's awesome and will answer all your
questions, and save you countless hours of frustration.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz

"Mark" <maworrell@.ananzi.co.za> wrote in message
news:ddbf09eb.0310231219.20065b09@.posting.google.c om...
> hope you can help.
> I need to get my access db backend to sql. I have tried the upsizing
> wizard but the get message "overflow" and cannot get any further.
> I also use queries that reference two date ranges from forms such as
> BETWEEN forms!form1!text1 AND forms!form1!text2. How can i achieve
> this in an sql view?|||One option for you. Just a thought. We use Borland Delphi as the main
language at work. It comes with an upsizing tool called 'Data Pump'
which is really useful for taking data from one db to another. I use
this quite a bit for Access -> SQL transfers. It may be worthwhile
doing a few searches on the Internet for this to see if Borland or
anyone else can help with a similar tool. We get it bundled with
Delphi (I think it's available with Paradox as well), but it may be
available as a seperate tool.

The problem you will have is with getting the structure copied over to
SQL. If you can find a way of creating the correct table structure in
the SQL db, then you can easily link the table through ODBC into
Access and import the data through a query. Problem is the structure
has to be there already.

If you only have a few tables and they aren't too big, I'd look at
creating them by hand on SQL instead of spending time looking for ways
to move the data. Moving the data is the easy bit.

"Jerry Boone" <jerry@.antech.biz.nospam> wrote in message news:<Z7rub.1119$LL3.330@.newssvr23.news.prodigy.com>...
> You will need lots of advice. I suggest that you buy "Microsoft Access
> Developer's Guide to SQL Server". It's awesome and will answer all your
> questions, and save you countless hours of frustration.
> --
> Jerry Boone
> Analytical Technologies, Inc.
> http://www.antech.biz
>
> "Mark" <maworrell@.ananzi.co.za> wrote in message
> news:ddbf09eb.0310231219.20065b09@.posting.google.c om...
> > hope you can help.
> > I need to get my access db backend to sql. I have tried the upsizing
> > wizard but the get message "overflow" and cannot get any further.
> > I also use queries that reference two date ranges from forms such as
> > BETWEEN forms!form1!text1 AND forms!form1!text2. How can i achieve
> > this in an sql view?|||Mark:

> I need to get my access db backend to sql. I have tried the upsizing
> wizard but the get message "overflow" and cannot get any further.

Check this kb:

http://support.microsoft.com/suppor...s/q272/3/84.asp

> I also use queries that reference two date ranges from forms such as
> BETWEEN forms!form1!text1 AND forms!form1!text2. How can i achieve
> this in an sql view?

Might want to look into stored procedures or user defined functions.
You could also apply your criteria after the view is defined. IE:
Select MyInfo from MyView Where MyDateCol Between '2002-12-12' and
'2002-10-12'.

HTH.

BZ

maworrell@.ananzi.co.za (Mark) wrote in message news:<ddbf09eb.0310231219.20065b09@.posting.google.com>...
> hope you can help.
> I need to get my access db backend to sql. I have tried the upsizing
> wizard but the get message "overflow" and cannot get any further.
> I also use queries that reference two date ranges from forms such as
> BETWEEN forms!form1!text1 AND forms!form1!text2. How can i achieve
> this in an sql view?