Thanks, Steve.

1. I have tried also without the server name preceding 'Administrator' to no avail.

2. Where would I find this password policy?

WendellB,

This was planned to be a daily export/import task. But looks like I'm off the hook for now since they're revamping and migrating their data to SQL Server 🙂

Thanks again, this was the case.

One more question, Luis Cazares. When I import, why doesn't the INT (in the first column of my data file) read in as is? When I run the import command,...

Thank you, sir. This helps greatly.

Seems to be answered HERE[/url].

I'll be researching more on the format file to understand this better.

At the moment, I have no clue of how many columns. I will need possibly only two columns, (e.g., name, course, grade). As for rows, it may be a lot...

I think they're suggesting I take the simpler approach of writing the export in VB Script, which I found something like:

Dim connStr, objConn, getNames

connStr = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Users\TestUser\Documents\TestDB.accdb"

Set objConn =...

Actually, yet another snag 🙁

I will not be allowed to install MSSQL on the machine. I will only be allowed to export from the MS Access DB, and I'll import...

Thanks John Rowan, do you have any leads on where to begin reading more on this? I found this so far. What do you think?

Thanks, WendellB. Unfortunately, I'm not familiar with the entire setup, so I may not be able to do as you suggested with storing in MSSQL and create a link from...

Thanks, John! And I understand your point, but I had to output table stats to pipe delimited files. Thanks again, I wish I could give +1 for this one.

I know this is an old post, but how does this work? I have tried the following:

EXECUTE sp_MSforeachtable

'EXECUTE master.dbo.xp_cmdshell ''osql -E -S "MYSQLSERVER" -d "MyDB" -q "sp_help ''?''" ' '...