By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,314 Members | 1,772 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,314 IT Pros & Developers. It's quick & easy.

Copying table from Access db to another Access db

P: 8
I have 2 databases DB#1 abd DB#2. I have TableA in DB#1 which needs to be copied in DB#2 but while doing this I need to change the field#1 which is currently of data type text.

Steps taken:

1. Created Macros with Action:TransferDatabase which helps me in copying the table from DB#1 to DB#2.
2. One of the fields in TableA has data type Text and values like 0040141699, now when I transfer TableA in DB#2 I want 00 to be removed from the value. Is this possible and how?

I would really appreciate any help on this.


P.S- I am not very proficient in Access as I have just started working on it
Aug 20 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,412
Do you want to get rid of all leading zeroes? Try Val(FieldName).
Aug 20 '07 #2

P: 8
Do you want to get rid of all leading zeroes? Try Val(FieldName).

Thanks, but where do I have to include this, I am not clear on this. Pls help
Aug 21 '07 #3

Expert Mod 10K+
P: 12,412
You use it in a query as a calculated field or in an update query.
Aug 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.