C
Carl Morris
Access 2003 import wizard should support advanced import of Excel spreadsheet
data by the wizard when working on a Access SQL Project. I only get the
advanced options when I am working in a Access Database file.
Access 2003 also should better support conversion of a database file to a
project file, making sure that any syntax changes in the SQL statements
actually work. For instance, " : " is converted to ' : ' but that causes the
query editor to trim off everything left of and including the space after the
colon.
Basically more testing is needed to insure that Access works better on SQL
server.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...f60ae&dg=microsoft.public.access.externaldata
data by the wizard when working on a Access SQL Project. I only get the
advanced options when I am working in a Access Database file.
Access 2003 also should better support conversion of a database file to a
project file, making sure that any syntax changes in the SQL statements
actually work. For instance, " : " is converted to ' : ' but that causes the
query editor to trim off everything left of and including the space after the
colon.
Basically more testing is needed to insure that Access works better on SQL
server.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...f60ae&dg=microsoft.public.access.externaldata