Solola
Board Regular
- Joined
- Sep 23, 2003
- Messages
- 73
I have imported data from Excel into Access, and the import spreadsheet wizard did not allow me to change the data type as I was importing (it was grayed out). I guess this is my first question: why did it not allow me to do this? I realize the way around this is to be sure that my data is formatted the way I want it in Excel BEFORE I import into Access, but shouldn't it allow me to change it? Why have the option there, if it's not going to let me use it? I assume I'm doing something wrong (?).
Second question (the REAL question/purpose of this post):
Now that my data is in Access, I need to change this field from a number format to text. I don't want to do this manually, b/c I've created a series of queries that ultimately get me the data I want. I will need to repeat this process with new data every month, so I want to just be able to import from Excel and click down the line of queries. I don't want to have to remember to manually go into the design of a table after I create it in step 7 and change the format of one field. I want to just create a field within the "make table" query (Step 7) that converts the existing number field to text. In Excel, I would just use the formula =TEXT(RID,"general").
This does not exist in Access, so how do I do this? Is it possible?
Second question (the REAL question/purpose of this post):
Now that my data is in Access, I need to change this field from a number format to text. I don't want to do this manually, b/c I've created a series of queries that ultimately get me the data I want. I will need to repeat this process with new data every month, so I want to just be able to import from Excel and click down the line of queries. I don't want to have to remember to manually go into the design of a table after I create it in step 7 and change the format of one field. I want to just create a field within the "make table" query (Step 7) that converts the existing number field to text. In Excel, I would just use the formula =TEXT(RID,"general").
This does not exist in Access, so how do I do this? Is it possible?