Skip to main content

Return to Question

fixed a tag
Link
BIBD
BIBD
  • 15.5k
  • 26
  • 89
  • 142
Misspelling
Source Link
Martin Liversage
Martin Liversage
  • 107.2k
  • 24
  • 216
  • 263

importing excel data into accesaccess

My VB.NET application is using importing some excel sheet into access

command.CommandText = "SELECT * INTO [MS Access;Database=" & current_db & "].[" & sheet_name & "] FROM [" & sheet_name & "$]"

The problem is that if I have some cells with the green error message in excel they are not imported in accesaccess. And they are actually in the same format they don't have a leading ' but excel it's saying number formatted as text.

An easy way out would be to simply correct this in excel but often users forget to do this and the data is skipped.

How can i force the connection to import a specified column as number ?

importing excel data into acces

My VB.NET application is using importing some excel sheet into access

command.CommandText = "SELECT * INTO [MS Access;Database=" & current_db & "].[" & sheet_name & "] FROM [" & sheet_name & "$]"

The problem is that if I have some cells with the green error message in excel they are not imported in acces. And they are actually in the same format they don't have a leading ' but excel it's saying number formatted as text.

An easy way out would be to simply correct this in excel but often users forget to do this and the data is skipped.

How can i force the connection to import a specified column as number ?

importing excel data into access

My VB.NET application is using importing some excel sheet into access

command.CommandText = "SELECT * INTO [MS Access;Database=" & current_db & "].[" & sheet_name & "] FROM [" & sheet_name & "$]"

The problem is that if I have some cells with the green error message in excel they are not imported in access. And they are actually in the same format they don't have a leading ' but excel it's saying number formatted as text.

An easy way out would be to simply correct this in excel but often users forget to do this and the data is skipped.

How can i force the connection to import a specified column as number ?

Source Link
Iulian
Iulian
  • 1.2k
  • 5
  • 23
  • 47

importing excel data into acces

My VB.NET application is using importing some excel sheet into access

command.CommandText = "SELECT * INTO [MS Access;Database=" & current_db & "].[" & sheet_name & "] FROM [" & sheet_name & "$]"

The problem is that if I have some cells with the green error message in excel they are not imported in acces. And they are actually in the same format they don't have a leading ' but excel it's saying number formatted as text.

An easy way out would be to simply correct this in excel but often users forget to do this and the data is skipped.

How can i force the connection to import a specified column as number ?