| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.access.modulesdaovba.ado,microsoft.public.excel.programming
|
|||
|
|||
Import csv to different tables
Got it, thanks. It is done now.
"Douglas J. Steele" wrote: "Angus" wrote in message ... 2. The PO number is 071378 but it becomes 71378 in Access even the format is text, how to make it exactly the same as what it is (start with "0" if there is a "0")? my code is as followed: rsHD!CUST_PO = Mid(TextLine, 172, 20) Is CUST_PO a numeric field, as opposed to a text field? Numeric fields do not keep leading zeroes: for a numeric field, 071378 and 71378 are identical. I'm assuming CUST_PO is the customer purchase order number, so it's doubtul you'll ever be doing arithmetic with the value! the format is given as text format, and it comes with 071378, I hope to keep it as text format so in future I have a chance to map it with original data. You didn't answer the question. What is the data type of the field CUST_PO in the table that's part of recordset rsHD? If you're losing leading zeroes, it must be Number, not Text. Change it to Text, and your problem will go away. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How import multiple tables from same web page (Web Query)? | Excel Discussion (Misc queries) | |||
| Import data from multiple tables | Excel Programming | |||
| I can import Access Tables. But, I can't import Access queries | Excel Programming | |||
| Import Queries instead of Tables (ADO) | Excel Programming | |||
| Import Queries instead of Tables (ADO) | Excel Programming | |||
Threaded Mode
