Bill, That's annoying. I see why it might do that if it were importing to a new table. However, why doesn't MS let me decide what the data is? Can you tell them to fix this bug?
Jeff, I'm familiar with automating Excel including doing so from Access. This is a file I get sent monthly, not one I create. The file has a different name each month (e.g., FileMarch.xls, FileApril.xls). The column headers (row 1) are similarly different each month. It's a rolling 12-month report of revenue and volume by AcctNo. Different types of accounts have different types of alpha-numeric formats. There is one type that is numeric only.
I suppose I could write code in Access that would add a leading single quote to that column, then import it. I'd have to manually enter the name of the file. I think that would be easier than having to rewrite the query copying from the new table to my working table each month (because the field names in the new table would be different each month).
Thanks
Adam
Posted by: runuphillracing@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar