microsoft.public.access.externaldata | Forum profile

  I would import it into a text field. Next I would run an update query to replace all the periods "." with nothing "" using the Replace function. Then I'd run another update query, again using the Replace function, to replace the comma "," with a period ".". Then you could use the Val function to convert the text string to an actual number as needed. --...

  Can I import data from an Excel spreadsheet into an Access database and identify what information is updated and what information is not updated?  

  I am trying to utilize two tables (customers) & (Invoices) to export filtered data to 3 separate sheets. I have seen the code in Ken snell's site yet i am not sure if this can be the soultion for me to use. Can anyone assit in directing me since it seems complicated .  

  On Oct 30, 7:12?pm, cgilmour2 <cgilmo...@discussions.microsoft.com> wrote: > Could someone tell me how to insert one column, or field, from one database > into another? ?It has to carry over the data in the field. > > Thank you :) If the field is already defined, then you can link to the external table, write an update query and then run it using DBEngine(0)(0).Execute "update...

  I wish to import a delimited text file where the bar character (|) is used as the column delimiter and the broken pipe (?) is used as the record delimiter. The standard import does not allow you to specify the record delimiter. The file contains unquoted text that contains punctuation and return character codes so I can't even do a search and replace on the file prior to import. Any suggestions please?  

  Peter Schmidt wrote: >I wish to import a delimited text file where the bar character (|) is used as >the column delimiter and the broken pipe (?) is used as the record delimiter. >The standard import does not allow you to specify the record delimiter. > >The file contains unquoted text that contains punctuation and return >character codes so I can't even do a search and replace on the...

  I have a question, I am importing data into a table, if I use a macro to create a table then 1,000 records = 1,00 records in table. If, though, I copy and Edit paste special, 1,000 records can = 900. Any thoughts? There are no filters or unique record identifiers, although the imported data cells can hold 1,500+ characters, record type is set to Memo in thse cases  

  My question is how do you change the format date to another format date. for example: in my file all date like this:2009/09/14 but i want to convert to 2009-09-14 ofcourse i have done like following but noting happen: 1-Select Date in the Category list. 2- Select a date format in the Type list. Does anyone know how to do this? If anyone can offer any suggestions about how to convert date I'd love to hear them. Thanks, ashrafi...

  Today, I attempted to open an OBDC data source to download new table configuration. Windows 7 is defaulting to a new directory called Libraries > Documents and when I select ODBC as the file type (bottom right of Open Files box), I get an error that says "Microsoft Office Access does not support opening HTML pages". However, if I then change the directory to Desktop > Allan_K > My Documents...

  Assuming that the field in which the dates are stored is a Date field, you do not need to do anything to the data itself. Just change the Format that is assigned to the field. yyyy-mm-dd -- Ken Snell http://www.accessmvp.com/KDSnell/ "ashrafi" <ashrafi@discussions.microsoft.com> wrote in message news:D736B8A8-FD20-49EC-8609-D3CF21767F90@microsoft.com... > > > My question is how...