My Assistant
Site Message
(Message will auto close in 2 seconds)
 Can't change the field properties when importing data
|
|
 Jun 21 2004, 01:23 PM
Post
#1
|
|
|
New Member Posts: 5 From: Gauteng South Africa  |
Importing text field into a table via the wizard, but can not change the field properties. I had to go to advanced options and change it there. Quite annoying if you are not familiar with the data you are importing! Any ideas?
|
 |
 
|
 |
Replies
(1 - 3)
|
Jun 21 2004, 01:35 PM
Post
#2
|
|
|
UA Editor + Utter Access Ruler Posts: 1,844 From: California, USA |
Where are you importing from. When you import into an existing table, the properties should have been set up already. If you are importing a text file into a new table you should be able to change the properties without going to advance option. However if this is something you'll be doing regularly it's a good idea to use the advance feature and save the specs.
Good luck. |
|
|
|
|
Jun 21 2004, 01:41 PM
Post
#3
|
|
|
New Member Posts: 5 From: Gauteng South Africa |
Importing a csv file into a new table. In Access 2000 you could click on the fileds in the preview window and that would allow you to change properties, but in 2003 you can click on the fields in the preview window, but nothing happens!
|
|
|
|
|
Jun 22 2004, 12:16 AM
Post
#4
|
|
|
UtterAccess VIP Posts: 6,250 From: Khon Kaen, Thailand |
Can you create a specification for the import? Then use it again for the next import.
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif) |
|
|
|
 |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 06:40 PM |