I have files in Excel Format that i wish to upload into informix database. I dun want to export the files into ascii delimited text. please advice
http://www.experts-exchange.com/Database/Miscellaneous/Q_10023431.html
Zones:
DatabasesDate Answered: 09/15/1997 Rating: 6.4 Views: 0
1. Is there a way using some VBA code or a query, to create a table, and then saving it as XLS so that it can be opened by Excel? If so how?
2. Is there a way in a query, although it creates a lar...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10136364.html
Zones:
MS AccessDate Answered: 03/08/1999 Rating: 6.0 Views: 0
I need a Network Days Function that can count business days between a field named StartDate and a field named EndDate, which will not count weekend days (Saturdays and Sundays), and also not count ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10147513.html
Zones:
MS AccessDate Answered: 04/08/1999 Rating: 8.8 Views: 0
I look for good example of Export to Excel:
* cell format(font,colour,border,size);
* how build a table from Access ? ;
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10198260.html
Zones:
MS AccessDate Answered: 08/27/1999 Rating: 7.4 Views: 0
I am interested in being able to launch external applications from forms. For example, I would like to be able to invoke SQL*LOADER from a button (w-b-p trigger) within forms so I can LOAD data in...
http://www.experts-exchange.com/Database/Oracle/Q_10255949.html
Zones:
OracleDate Answered: 01/17/2000 Rating: 6.8 Views: 0
I need some assistance in exporting data from a table to an Excel Spreadsheet. The problem I have is trying to get the export to put data, based on critera, to go into one spreadsheet but on sever...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_10324214.html
Zones:
FoxProDate Answered: 04/11/2000 Rating: 6.8 Views: 0
Folks,
I want to set up one database that will email (using SendObject) the results of a query to another user, who will then import that data (using TransferSpreadsheet) into her database.
S...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10326941.html
Zones:
MS AccessDate Answered: 04/13/2000 Rating: 5.6 Views: 0
I have an Access application that uses Excel to analyze some data. The application works fine, except I cannot seem to remove Excel from memory. Below are the pertinent sections of code. After th...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10349096.html
Zones:
MS AccessDate Answered: 05/16/2000 Rating: 5.8 Views: 0
Here is the deal I am opening a speadsheet from Excel that is already linked in Access. I wnt to Open Excel and the speadsheet use the info from it and closing Access I what the program to close a...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10581081.html
Zones:
MS AccessDate Answered: 07/07/2000 Rating: 6.2 Views: 0
I doubt this is possible without a custom program, but thought I would check here first. I have some data in different Excel files that I would like to send an Access database. The Excel files ar...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10958161.html
Zones:
MS AccessDate Answered: 08/13/2000 Rating: 7.8 Views: 0