Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

changing datatype

Status
Not open for further replies.
rjumelet

rjumelet

Programmer
Joined
Jul 5, 2002
Messages
5
Location
NL
I've imported a dbf-file in Access 2000. And I want to change the column datatype from text to numeric.
What code of VBA can I use.
 
Sort by date Sort by votes
It is probably safer to create a new field based on the old field, setting the datatype of the new field to what you want and copy the data into this new field - this way you do not lose the original data
Simon
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

IcarusHallsorts
  • Locked
  • Question Question
Changing a command button by VBA
Replies
8
Views
1K
mikrom
mikrom
EliseFreedman
  • Locked
  • Question Question
Changing source of all pivot tables in a workbook
Replies
8
Views
370
SkipVought
S
Walter Cuypers
  • Locked
  • Helpful tip Helpful tip
Changing number format properties of field in a Microsoft Access 2013 Database
Replies
1
Views
209
Walter Cuypers
Walter Cuypers
KeyserSoze
  • Locked
  • Question Question
Changing a table field's property
Replies
10
Views
697
KeyserSoze
KeyserSoze
Cotton9
  • Locked
  • Question Question
Macro assignment to button changing
Replies
3
Views
265
Cotton9
Cotton9

Part and Inventory Search

Sponsor

Back
Top