• Importing data from an Excel spreadsheet

    Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: How can I get the new data into the database and maintain the relationships and...

    Bluize20 pointsBadges:
  • How to access a Microsoft Access database through Python

    Is there a way to access a Microsoft Access database through Python? Or even with SQL? I'm looking for a solution that works with Linux but even Microsoft Windows would work. I would appreciate any advice.

    ITKE351,965 pointsBadges:
  • Import Microsoft Access tables into Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • Visual Basic 6.0 assistance

    I have a problem with searching through my MS Access database. Can you help me please?

    macedavinie925 pointsBadges:
  • Database Migration code in MySQL

    Code to migrate database in MySQL (tables, triggers, stored procedures, functions and views) to Oracle, MS Access & vice versa.

    akashi5 pointsBadges:
  • Microsoft Access Date

    Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() 'Sets the Date From and Date To text boxes 'to Today's Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today's date into my From and To Date fields. The problem is I have these From and To...

    Vadle35 pointsBadges:
  • Send data from SQL Server to MS Access

    I'm a beginner to VB.NET andI want to transfer my data in SQL Server to MS Access. Please anyone can help me to this regard?

    Usjpcha10 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • MS Access DATABASE and combobox in VB6.0

    hellooo plz i need help  i am new to VB6.0 and i've learned alot now i have a database in MS Access and i want to create a combobox named (Combo1) that will be populated from the field (Name) in table (Customer) in the database (weighbridge.mdb) and then when i choose a name in the combobox i want...

    Ahedfares895 pointsBadges:
  • Duplicate Records

    Hello, How can I find duplicate records in access based on more then ten fields? The wizard only allows 10 fields. I need to find duplicate records based on 17 fields. Is this possible in access? Or is there another way around it? Thanks in advance!

    ArfaaMujeeb0 pointsBadges:
  • What is the procedure for Deployment in VB 6.0

    Dear Friends, I have developed a small project using Visual Basic 6.0 as front End, MsAccess for database & VB reports for reports on OS Windows XP SP2.  It was completed successfully and working on my system but how to transfer or make it work on other system where VB is not available....

    SailajaConsultancy5 pointsBadges:
  • How to read HTML in Lotus Notes inbox messages in VBA

    Can anyone show me how to get html from Notes inbox messages in VBA? I am using Access VBA to send notes email messages.  The message is a form I'm asking the recipient to fill out and return.  The message contains html with <select> and <input> elements.  The replies come back and...

    JoeLilly5 pointsBadges:
  • Problem deleting an object (form) in Access 2000

    When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas?

    Eamonngarvey5 pointsBadges:
  • Loading CSV files into Oracle tables

    I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use...

    Gaugelc0 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to implement crosstab query in Access?

    How to implement crosstab query

    Shamu75 pointsBadges:
  • Equivalent for crosstab query

    Is there any function in MySQL that can create a query similar to crosstab query in MS Access?

    Sgheorghian5 pointsBadges:
  • SQL MS Access – Displaying output in a certain order

    Hi Team, SELECT mergeddatabase.Roomno, Count(*) AS Boxesscanned, Sum(mergeddatabase.Currentweight) AS RoomsTotalweight, mergeddatabase.Currentdate AS RequestedDate FROM mergeddatabase WHERE (((mergeddatabase.Currentdate) Between [Forms]![FrmDateRange]![TxtStartDate] And...

    Witsend10 pointsBadges:
  • Best way to create a large Access databases.

    I am new to Access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I would like to know is it better to break up the database in to several linked databases together or just have one and live with it.

    Opus35 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following