bfuchs
asked on
Looking for a shortcut to convert Access table/s to SQL.
Hi Experts,
I'm looking for a shortcut to convert Access table/s to SQL.
Table have dozens of fields, many with long names (no illegal names like spacing etc..).
Everything must stay the same, no re-naming, changing types, organizing etc.. otherwise FE app will fail.
What is the easiest way?
I'm looking for a shortcut to convert Access table/s to SQL.
Table have dozens of fields, many with long names (no illegal names like spacing etc..).
Everything must stay the same, no re-naming, changing types, organizing etc.. otherwise FE app will fail.
What is the easiest way?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Interesting i have to check it...i always use ADO when i deal with SQL ...do you have some more info ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Experts,
I was not in the office today, hope to be there tom & get to test those suggestions.
Thanks for all replies.
Ben
I was not in the office today, hope to be there tom & get to test those suggestions.
Thanks for all replies.
Ben
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Experts,
I ended up using the following, and very happy with the outcome.
Thanks to all participants.
Ben
I ended up using the following, and very happy with the outcome.
If you use Import / Export wizard within MS SQL Management Studio (it's actually an SSIS package!) you can get all your tables in SQL Server.
Thanks to all participants.
Ben