Improve importing from Excel - Allow field type to be changed

  • Thread starter Thread starter slb52
  • Start date Start date
S

slb52

Improve importing from Excel - Allow field type to be changed like you can do
when you import from a text file. Many times the default does not match what
is mostly in the col.

----------------
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...1d94a&dg=microsoft.public.access.externaldata
 
This can be done in Access 2007. I doubt if they will go back and change
previous versions. However, if you save your Excel spreadsheet as a CSV
file, you can import it as text and modify the field types. That's what I
usually do.
 
Back
Top