Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LegalizeTheTruth

    Import ODBC table into a different database (not into the current one)

    Hello! It might be an easy question for you, but I don't find an answer to it. I have the following code, which works perfectly: DoCmd.TransferDatabase _ TransferType:=acImport, _ DatabaseType:="ODBC Database", _ DatabaseName:=init.dbLogin, _ ObjectType:=acTable, _...
  2. LegalizeTheTruth

    Access/VBA: Unparsable Record when exporting into text with Schema.ini

    Yeah, I know this option too. I was using it like this until a bumped into another problem. The thing is that you can not export more than 2 decimal places into a text file. This is the main problem. Access use the Regional settings from windows. The database I'm working with will be used by a...
  3. LegalizeTheTruth

    Access/VBA: Unparsable Record when exporting into text with Schema.ini

    It's there, but sorry, I was not clear enough with this. So it has 3 fields, and the FieldNames (Types) are: Name (Text) Age (Long Integer) SomeNumber (Double) Only 1 record in this table: Steven 27 3 Or have I misunderstood something? This table is just for testing, so I can check the output...
  4. LegalizeTheTruth

    Access/VBA: Unparsable Record when exporting into text with Schema.ini

    Hey all, I've got a problem which is driving me crazy now. I'm trying to export a table into a txt with the help of the Schema.ini file. I'm using the following code in this file (which I've placed into the folder where I'm exporting to): [Mytable.txt] ColNameHeader=True Format=TabDelimited...

Part and Inventory Search

Back
Top