Search results for query: *

I have a program which imports .txt files from a mainframe download directory and imports this data into SQL 2008 tables. The file names are contained in the importing database in a file location table. It lists the file import URL and the import table location. The file sizes generally are...

If your time stamp must be based on the local time you will have issues with people traveling. Someone from New Yord travels to California with a laptop. How do you control the time stamp? Bill

Code 3 of 9 only has 43 characters available and none of them are alt or ctrl characters. Generally speaking barcodes are data driven not control driven characters. If you want to have special characters to do special thing then you will have to write a program to use the character strings you...

I am listening to all the heartbreak these massively complex spreadsheets cause and feel the pain everybody is suffering. The real solution is to stop using spreadsheets as databases and convert to a true database. The spread sheet linkage rules and single user usage make it difficult for...

Another approach is to send the printout to Microsoft Office OneNote. It will capture the printout and you can include it in any document you want as a jpg or a png image. Bill

First, a .dbf file will transfer into a table within an .mdb. Second, what is the source of the .dbf is it dBase or VFP or another xBase? A dBase file can be linked or imported. A VFP file must be linked but I am not sure with what as I have never done that.

The following is from the dBase 5.0 language reference as an option to the BROWSE command. 'FREEZE confines you to one field or column in the file. If the field has been made read-only, you may not edit it. Other fields in the field list or database file table can display on the screen if they...

On another topic I wondered why MS gave the import functionality of importing from individual worksheets in Excel yet exporting to worksheets requires COM functionality. Why can Excel open a dBase .dbf yet fails to open a Foxpro .dbf?

Do a search in Google for sector editor. Its been years since I did any of this type of investigation and I did not have good results. I am not sure how the current operating system read/write data to the disc.

If all else fails read the file with a byte editor and look at the record where the file stops copying. Compare it to the previous record and see if they are encoded the same. You may be able to salvage the file using this approach. If you can't read the data then there probably problems with...

Whoever has the database will have to find the file. It could be an .mdx file also.

The index is a seperate file in dBase. Access should allow you to still import the data as the indexes are completely different between the two applications. You can then build your own Access indexes.

I can think of (3) ways to get your file imported. Open the file in WordPad and do a replace the "|" with a comma. Depending on the file size. Create a new database and import into a single field and parse the field into individual fields. If the data is longer than 255 characters create...

In the past using a dot matrix printer to make a barcode was not acceptable. The scanner couldn't read the codes. It can be done with a laser printer but you will have to either buy the font cartridge for the printer if you are using DOS or if you are using dBase within Windows you will have to...

Why are you using acceleration use the velocity. Set your velocity in a variable and compare each velocity. Output when new velocity is larger than old velocity. Change velocity variable every cycle.

ddelk There are different formats which you can export to, one of them is fixed length text. You may have to limit each record to 255 characters but if you are having a problem with extra data you can strip this data as it will always appear in the same location in a fixed length text record...

When you export to dBase specify a fixed length format. If Access sends you extra data you can strip the data down by defining a dummy field in the dBase database which begins at the decimal point putting the decimal into a seperate field.

My past experience with ACT was that it was run by a customized DB engine and wasn't compliant with the standard .dbf ODBC driver. I tried opening the database with dBase IV and Access. Try calling ACT and find out if their DB is compliant now or not. ACT is now selling a query tool, Stonefield...

You didn't mention how you are connecting to the internet. If through a cable modem and trough a cable company you may have to ipconfig /renew for a valid ip. Also some people require you card ID.

Your modem may have the auto answer turned off and the software on the server may be doing it at initiallization. Another problem may be the PBX. Lines can be configured at the PBX to do just about anything these days and it may not be allowing calls to go to that number only outgoing calls for...