You could use SQL Server Management Studio to import from MS-Access.

Connect to the SQL server, click the Databases node to expand the list, right-click on your database and select Tasks...

yes, it removes the period PLUS any characters that follow the period.

I would like to point out that the expression

If InStr(PID, ".") > 0 Then

PID = Left(PID, InStr(PID, ".") - 1)

End If

will truncate the string starting with the first "."...

Wendell's comments are spot on.

I would add that if you have 100 users, then make sure that each user has their own copy of the Access file.

EDIT: oops, he already...

I ran the original version of the script & found a table that had an identity column, but the clustered PK was actually two other columns :w00t: so thanks Doran.

Here is an article I wrote a couple years ago...

http://wvmitchell.blogspot.com/2012/01/sql-list-columns-in-table-updated.html

and the source code is here: http://www.wvmitchell.com/blogger/wm_columns.htm

this only works for tables. I have another version of views...

This will list ALL of the user tables with the locations where they are used. You could substitute your "table of table names" in place of sys.tables...

SELECT

t.name AS table_name,

OBJECT_NAME(m.object_id) AS...

Answered my own question - all I had to do is go into Control Panel ~ Programs & Features and Change the resharper settings to skip 2005 and 2008.

I would suggest that you sign up with LinkedIn and glassdoor.com you can search by job title and area for salaries & company reviews.

Back to the OP, in the event that somebody actually needs help...

If Access is prompting for a password, but there was no database password set - then the file cannot...

What is "SubQryTab05forAppend" is that an Access query or SQL view? If it is an Access query, the pass-thru cannot see it.

Can you run just the SELECT portion of the...

Take a look at SSMA, it is not a scripting solution but makes it very easy to migrate:

Microsoft SQL Server Migration Assistant for Access v5.2

http://www.microsoft.com/en-us/download/details.aspx?id=28763

"SQL Server Migration...

You could use DSN-less connections. The first code will attach one table:

Sub AttachOne(TableName As String)

Const my_connection = "ODBC;DRIVER=SQL Native Client;SERVER=my_server;UID=my_username;PWD=my_password;DATABASE=my_database;"

'

...

Here is an example of a possible method you could use:

-- set up sample table with data

IF OBJECT_ID('dbo.my_table') IS NOT NULL

DROP TABLE dbo.my_table

GO

CREATE TABLE dbo.my_table

(

ID int identity(1,1) NOT NULL,

F1 varchar(4),

F2...

Regardless of which method used, you should really look up the data types & sizes in BOL so you can properly declare the columns / variables ...

for INFORMATION_SCHEMA.TABLES:

TABLE_SCHEMA nvarchar(128)

TABLE_NAME sysname

for...