new tables everyday

We have a software package that exports its data in MS Access 97 and 2000
formats. It overwrites and creates a new Access file each time it exports.
These exports serve a handful of front end applications. I'd like to get
this data tied to our SQL 2005 server. Any suggestions on whether to look at
just linking these in vs importing, etc?Hi,
Are you using the data imported just to query against it from an application
that connects to SQL Server? In that case you can indeed avoid the hassle
of importing by setting up linked servers (see
http://msdn2.microsoft.com/en-us/library/ms190479.aspx). This will allow
you to access your data over connections to the SQL Server using a four part
object name i.e. linkedservername.database.schema.table. You can also use
functions like OPENROWSET and OPENDATASOURCE, but if you access the external
data in various places in your code then I would suggest that you use linked
servers instead.
Jonathan
"Schmeg" <sschmeg@.yahoo.com> wrote in message
news:OE54Ig14HHA.1484@.TK2MSFTNGP06.phx.gbl...
> We have a software package that exports its data in MS Access 97 and 2000
> formats. It overwrites and creates a new Access file each time it exports.
> These exports serve a handful of front end applications. I'd like to get
> this data tied to our SQL 2005 server. Any suggestions on whether to look
> at just linking these in vs importing, etc?
>|||On Aug 20, 11:31 am, "Schmeg" <ssch...@.yahoo.com> wrote:
> We have a software package that exports its data in MS Access 97 and 2000
> formats. It overwrites and creates a new Access file each time it exports.
> These exports serve a handful of front end applications. I'd like to get
> this data tied to our SQL 2005 server. Any suggestions on whether to look at
> just linking these in vs importing, etc?
Why do you export the data to Access? Is it for off line use or just
because? I support multipule Access Projects that connect directly to
MS SQL server and they have thousands of lines of code for working
with the data. This works well and is good for rappid development.
On the other hand if you only want a couple of the tables in the SQL
DB available for the users to work in then link the tables in access.

New Line in HTML

Hi,
I have a field header with multiline ( ascii chr(10) ). But it does not
shown in HTML but does in other formats. Because it is rendered as is and
not as <BR>.
Is it any way to show the newline?
TIA,
SamuelYou need both a carriage return and a line feed. (chr(13) and chr(10))
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:%233t4P3$bEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a field header with multiline ( ascii chr(10) ). But it does not
> shown in HTML but does in other formats. Because it is rendered as is and
> not as <BR>.
> Is it any way to show the newline?
> TIA,
> Samuel
>|||Hi,
Thanks - It works.
Can you tell me the way to show multiple spaces instead of one space
( ) in HTML?
TIA
Samuel
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:%23mJoEZDcEHA.3804@.TK2MSFTNGP10.phx.gbl...
> You need both a carriage return and a line feed. (chr(13) and chr(10))
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Samuel" <samuel@.photoninfotech.com> wrote in message
> news:%233t4P3$bEHA.2972@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I have a field header with multiline ( ascii chr(10) ). But it does not
> > shown in HTML but does in other formats. Because it is rendered as is
and
> > not as <BR>.
> >
> > Is it any way to show the newline?
> >
> > TIA,
> > Samuel
> >
> >
>