Search results

Importing data into a table Regarding the *.xls import. I attempted to import the file into acopy of the table after copying its structure and due to its file size, it takes and absolute age to import the data!! Any other suggestions? Thanks

Importing data The way in which the table is structured will not allow for an *.xls import? The table has been in use for some time now and I do not really want modify its structure as this is an important reporting system that is used each and every day. It only allows for a CSV import. The...

CSV file import The data being imported is not in fact a total, all of the data is text (characters) and is a summary of data from an import from a system we use. It seems strange it imports all data barring the last two fields.

Importing into an MS Access table Thanks for the reply. I have created an import specifcation using an ODBC data source but this does not seem to solve the porblem. It only picks up that there are 36 data sources (columns) within the text file. The file is delimited and is split by commas. Any...

Importing into a table Apologies for the late reply. I have tried to import the file into Excel and it worked fine. I can only assume there is a limit on the number of columns in a table you can import into? Does anyone know of any newer releases of the import wizard that have been released by...

Does anyone know the maximum number of columns a CSV file can be imported into an Access table? I cannot seem to import data into more than 36 columns, and I need to be able to import into 37 columns.........So frustrating!!!

Does anyone know the maximum number of columns a CSV file can be imported into an Access table? I cannot seem to import data into more than 36 columns, and I need to be able to import into 37 columns.........So frustrating!!!

I have a form that contains multiple buttons. One of the buttons runs a macro, that runs a query to import a set of records from a CSV file. I need to create a piece of code that counts the number of records, does a sum of the total, and places a date time stamp on the values. I need this to be...

I have managed to resolve this. I had missed a vital declaration in the module when programming the text transfer, thanks for the help provided.

Microsoft Access 97

This is the problem I am having. I am attemoting to import a CSV file into a temporary table in MS Access. I have set-up an import SPEC that lists the columns the data must go into. I have wirtten a module, that automatically calculates the file to be imported from a location on my PC. The...

This is the problem I am having. I am attemoting to import a CSV file into a temporary table in MS Access. I have set-up an import SPEC that lists the columns the data must go into. I have wirtten a module, that automatically calculates the file to be imported from a location on my PC. The...