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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

change the data type on one row from number to text

Status
Not open for further replies.
splendidmonkey

splendidmonkey

Technical User
Nov 21, 2001
17
0
0
GB
Ok then here it is I am importing a Excel sheet into access then reformatting it. But one thing I need to do is after I import before the reformat is I need to change the data type on one row from number to text using ether some code or a macro as it needs to be automated.

Any idea’s

Jez
 
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
179
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
91
Viswa.R
Viswa.R
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
137
Moss100
Moss100
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
287
Andrzejek
Andrzejek
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
99
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top