...another thing, you could get the following error if the spreadsheet is open. It needs to be closed when accessing it.

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB...

Fairly often, I've got to get data from excel or into excel, and I've used the following type of insert from query analyzer.

insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

  'Data Source="S:\folder\Test.xls";Extended properties=Excel 8.0')...Sheet1$...

Hi,

I'm not sure exactly what method you are using to connect..

...but if you are using a linked query you can edit the DSN from the "Data" menu option, then choose...

I've had problems with my orders there myself, but I'd hate to swear them off. When I shop there, I buy what's on the shelf and I don't order anything anymore from...

Ideally, you'd want to backup but if you can't get that working, and you're at wits end, you might consider detaching the databases and copying the mdf and ldf files out...

You can put the following code into a new module in the access database to dump out the code for all reports, forms, and modules. It creates a single textt file and is...

Hi Mark,

Thanks for the reply. The pdf file I'm dealing with is compressed, so I can't do a straight file read.

I did find some code at http://www.codeguru.com/forum/archive/index.php/t-26418.html that works...

In a worst case scenario, you may have a object (report,form, etc) that is corrupted beyond repair and causes the import to fail or corrupts the new db. If that's the...

the bat file idea's good, although I'm having some trouble passing the parameters to it. After %9 I've read that I need to do some shifting to get all the parameters...

I'm only dealing with around 2000 records with an msaccess front end, so it looks like a front end write to file isn't a bad idea. If I were dealing...

I'd be doing this from a stored proc fired off from an application.

Would it be best to xp_cmdshell out and bcp then?

I'm thinking you can do something like this....

select a.rowid, a.data, b.userid

from tablea a

left join tableb on b.colorid=a.rowid and b.userid=100

..you could pass in a variable for the 100

Good catch, I need to add them. Thanks!

I use the following as a quick check to track differences of all user objects. Note: the servers must be linked.

Hope you fine this useful.

select

a.name as [Not in Database2],...